In [1]:
#!/usr/bin/python
#coding=utf-8
import numpy as np
import pandas as pd
from openpyxl import load_workbook
from xlrd import open_workbook
import csv
from csv import reader
import re
import os
from matplotlib import pyplot
from matplotlib import style
style.use("ggplot")
#%matplotlib notebook
import sys
import operator
import datetime
import time
import matplotlib.pyplot as plt
#%matplotlib notebook
In [2]:
def diffdates(d1, d2):
    #Date format: %Y-%m-%d %H:%M:%S
    return (time.mktime(time.strptime(d2,'%Y-%m-%d %H:%M:%S')) - time.mktime(time.strptime(d1,'%Y-%m-%d %H:%M:%S')))
In [3]:
filename1 = 'bigdata.xlsx'
df = pd.read_excel(filename1, sheetname='Data')
df = df[df.IdentNo.str[-2:] == "_G"]
In [4]:
# Add two more columns
print ("start")
df = df.values
a,b = df.shape
z = np.zeros((a,2))
df = np.hstack((df,z))
a,b = df.shape
print ("end")
start
end
In [5]:
#listing all unique products
print ("start")
varia = 0
list1 = []
while (varia < a):
    vari = str(df[varia][2]) + "_" + str(df[varia][3])
    t = len(list1)
    flag = 0
    for i in range(t):
        if list1[i] == vari:
            flag = 1
            break
    if (flag == 0):
        list1.append(vari)
    varia += 1
unique_sets = len(list1)
print (list1)
print (unique_sets)
print ("end")
start
['116_1038408484', '115_1038307052', '116_1038307052', '115_1038305585', '116_1038305585', '115_1038408318', '116_1038408318', '115_1038408484', '115_1038305594', '115_1038407804', '116_1038305594', '116_1038407804', '115_1038407806', '116_1038407806', '115_1038408272', '115_1038408104', '116_1038408272', '116_1038408104', '115_1038407334', '115_F005V16903', '116_1038407334', '115_1038408462', '116_1038408462', '115_1038407754', '116_1038407754', '115_1038305588', '116_1038305588', '115_1038407332', '116_1038407332', '115_1038408840', '116_1038408840', '115_1038305359', '116_1038305359']
33
end
In [6]:
#assigning product number depending on TTNR to the data-set
print ("start")
for i in range(a):
    concat= str(df[i][2]) + "_" + str(df[i][3])
    for ii in range(unique_sets):
        if (list1[ii] == concat):
            df[i][4] = ii + 1
            break
print ("end")
start
end
In [7]:
print ("start")
timers = 180
threshold_analysis = []
individual_variations = []

threshold_analysis.append([])
flag = 0
a,b = df.shape
count = 0
value_prev = "0"
date_prev = "0"
    
final_array = []
for i in range(a):
    if flag == 0:
        final_array.append([])
        final_array[count].append(df[i][4])
        final_array[count].append(df[i][1])
        flag = 1
    elif df[i][4] != value_prev:
        final_array[count].append(date_prev)
        count += 1
        final_array.append([])
        final_array[count].append(df[i][4])
        final_array[count].append(df[i][1])
    else:
        t1 = pd.to_datetime(date_prev)
        t2 = pd.to_datetime(df[i][1])
        time = pd.Timedelta(t2 - t1).seconds + pd.Timedelta(t2 - t1).days*24*60*60
        if (time > timers):
            final_array[count].append(date_prev)
            count = count + 1
            final_array.append([])
            final_array[count].append(df[i][4])
            final_array[count].append(df[i][1])
    df[i][5] = count + 1
    value_prev = df[i][4]
    date_prev = df[i][1]
    if (i == a-1):
        final_array[count].append(date_prev)

print (final_array)
np.savetxt("product_type.csv", df, fmt="%s", delimiter=",")
np.savetxt("timelist.csv", final_array, fmt="%s", delimiter=",")
start
[[1, Timestamp('2018-04-02 06:34:01'), Timestamp('2018-04-02 06:44:06')], [1, Timestamp('2018-04-02 06:47:38'), Timestamp('2018-04-02 06:47:38')], [1, Timestamp('2018-04-02 06:50:51'), Timestamp('2018-04-02 06:52:45')], [1, Timestamp('2018-04-02 06:56:41'), Timestamp('2018-04-02 06:57:33')], [1, Timestamp('2018-04-02 07:05:56'), Timestamp('2018-04-02 07:07:26')], [1, Timestamp('2018-04-02 07:17:38'), Timestamp('2018-04-02 07:19:06')], [1, Timestamp('2018-04-02 07:23:03'), Timestamp('2018-04-02 07:23:42')], [1, Timestamp('2018-04-02 07:30:15'), Timestamp('2018-04-02 07:51:57')], [1, Timestamp('2018-04-02 08:09:20'), Timestamp('2018-04-02 08:40:07')], [1, Timestamp('2018-04-02 08:47:04'), Timestamp('2018-04-02 08:48:39')], [1, Timestamp('2018-04-02 09:01:21'), Timestamp('2018-04-02 09:02:08')], [2, Timestamp('2018-04-02 09:27:57'), Timestamp('2018-04-02 09:36:45')], [2, Timestamp('2018-04-02 09:39:47'), Timestamp('2018-04-02 09:40:34')], [2, Timestamp('2018-04-02 09:46:17'), Timestamp('2018-04-02 10:29:57')], [2, Timestamp('2018-04-02 10:33:02'), Timestamp('2018-04-02 10:43:20')], [2, Timestamp('2018-04-02 10:47:34'), Timestamp('2018-04-02 10:49:01')], [2, Timestamp('2018-04-02 10:55:52'), Timestamp('2018-04-02 11:03:21')], [2, Timestamp('2018-04-02 11:07:50'), Timestamp('2018-04-02 11:42:06')], [2, Timestamp('2018-04-02 11:47:45'), Timestamp('2018-04-02 11:56:25')], [3, Timestamp('2018-04-02 12:06:47'), Timestamp('2018-04-02 12:36:26')], [3, Timestamp('2018-04-02 12:42:51'), Timestamp('2018-04-02 12:53:31')], [3, Timestamp('2018-04-02 12:59:11'), Timestamp('2018-04-02 13:02:36')], [3, Timestamp('2018-04-02 13:06:49'), Timestamp('2018-04-02 13:25:01')], [3, Timestamp('2018-04-02 13:29:11'), Timestamp('2018-04-02 13:34:46')], [3, Timestamp('2018-04-02 13:43:58'), Timestamp('2018-04-02 13:57:01')], [3, Timestamp('2018-04-02 14:02:11'), Timestamp('2018-04-02 14:10:28')], [3, Timestamp('2018-04-02 14:15:38'), Timestamp('2018-04-02 14:28:39')], [3, Timestamp('2018-04-02 14:33:45'), Timestamp('2018-04-02 14:37:05')], [4, Timestamp('2018-04-02 15:33:19'), Timestamp('2018-04-02 15:34:33')], [4, Timestamp('2018-04-02 15:38:25'), Timestamp('2018-04-02 15:51:03')], [4, Timestamp('2018-04-02 16:02:07'), Timestamp('2018-04-02 16:02:07')], [4, Timestamp('2018-04-02 16:24:42'), Timestamp('2018-04-02 16:29:52')], [4, Timestamp('2018-04-02 16:33:24'), Timestamp('2018-04-02 16:58:35')], [4, Timestamp('2018-04-02 17:01:39'), Timestamp('2018-04-02 17:08:54')], [4, Timestamp('2018-04-02 17:22:28'), Timestamp('2018-04-02 17:26:09')], [4, Timestamp('2018-04-02 17:29:38'), Timestamp('2018-04-02 17:32:44')], [4, Timestamp('2018-04-02 17:36:15'), Timestamp('2018-04-02 17:38:06')], [4, Timestamp('2018-04-02 17:41:50'), Timestamp('2018-04-02 17:43:17')], [4, Timestamp('2018-04-02 17:46:26'), Timestamp('2018-04-02 18:14:17')], [4, Timestamp('2018-04-02 18:17:25'), Timestamp('2018-04-02 18:23:10')], [4, Timestamp('2018-04-02 18:28:48'), Timestamp('2018-04-02 18:34:09')], [5, Timestamp('2018-04-02 18:42:28'), Timestamp('2018-04-02 18:52:59')], [5, Timestamp('2018-04-02 18:59:39'), Timestamp('2018-04-02 19:23:45')], [5, Timestamp('2018-04-02 19:32:44'), Timestamp('2018-04-02 19:52:01')], [5, Timestamp('2018-04-02 20:00:33'), Timestamp('2018-04-02 20:13:19')], [5, Timestamp('2018-04-02 20:24:52'), Timestamp('2018-04-02 20:29:46')], [5, Timestamp('2018-04-02 20:34:42'), Timestamp('2018-04-02 20:39:44')], [6, Timestamp('2018-04-02 21:02:38'), Timestamp('2018-04-02 21:03:17')], [6, Timestamp('2018-04-02 21:10:23'), Timestamp('2018-04-02 21:18:48')], [6, Timestamp('2018-04-02 21:23:05'), Timestamp('2018-04-02 21:27:15')], [6, Timestamp('2018-04-02 21:33:03'), Timestamp('2018-04-02 21:37:35')], [6, Timestamp('2018-04-02 21:40:46'), Timestamp('2018-04-02 21:54:06')], [6, Timestamp('2018-04-02 22:00:37'), Timestamp('2018-04-02 22:17:32')], [6, Timestamp('2018-04-02 22:21:27'), Timestamp('2018-04-02 22:23:28')], [6, Timestamp('2018-04-02 22:27:08'), Timestamp('2018-04-02 22:34:48')], [6, Timestamp('2018-04-02 22:38:46'), Timestamp('2018-04-02 23:53:19')], [6, Timestamp('2018-04-02 23:56:35'), Timestamp('2018-04-03 00:35:37')], [6, Timestamp('2018-04-03 00:40:14'), Timestamp('2018-04-03 00:43:03')], [6, Timestamp('2018-04-03 00:46:42'), Timestamp('2018-04-03 01:02:30')], [7, Timestamp('2018-04-03 01:40:45'), Timestamp('2018-04-03 01:53:24')], [7, Timestamp('2018-04-03 01:57:26'), Timestamp('2018-04-03 02:42:43')], [7, Timestamp('2018-04-03 02:47:37'), Timestamp('2018-04-03 03:26:57')], [7, Timestamp('2018-04-03 03:32:07'), Timestamp('2018-04-03 03:55:31')], [7, Timestamp('2018-04-03 04:08:56'), Timestamp('2018-04-03 05:04:37')], [7, Timestamp('2018-04-03 05:12:16'), Timestamp('2018-04-03 05:20:06')], [7, Timestamp('2018-04-03 05:24:07'), Timestamp('2018-04-03 05:39:55')], [8, Timestamp('2018-04-03 06:02:56'), Timestamp('2018-04-03 06:04:19')], [8, Timestamp('2018-04-03 10:59:54'), Timestamp('2018-04-03 11:04:54')], [8, Timestamp('2018-04-03 11:09:01'), Timestamp('2018-04-03 11:30:18')], [8, Timestamp('2018-04-03 11:35:10'), Timestamp('2018-04-03 11:47:22')], [8, Timestamp('2018-04-03 11:53:49'), Timestamp('2018-04-03 11:54:56')], [8, Timestamp('2018-04-03 12:09:38'), Timestamp('2018-04-03 12:09:38')], [8, Timestamp('2018-04-03 12:13:25'), Timestamp('2018-04-03 12:21:15')], [8, Timestamp('2018-04-03 12:28:45'), Timestamp('2018-04-03 12:32:17')], [8, Timestamp('2018-04-03 12:35:26'), Timestamp('2018-04-03 12:42:12')], [8, Timestamp('2018-04-03 12:48:45'), Timestamp('2018-04-03 12:48:45')], [8, Timestamp('2018-04-03 12:55:27'), Timestamp('2018-04-03 12:58:04')], [8, Timestamp('2018-04-03 13:32:46'), Timestamp('2018-04-03 13:32:46')], [8, Timestamp('2018-04-03 13:42:33'), Timestamp('2018-04-03 13:43:24')], [8, Timestamp('2018-04-03 13:50:09'), Timestamp('2018-04-03 13:56:56')], [8, Timestamp('2018-04-03 14:17:02'), Timestamp('2018-04-03 14:18:41')], [8, Timestamp('2018-04-03 14:24:17'), Timestamp('2018-04-03 14:35:41')], [8, Timestamp('2018-04-03 14:38:59'), Timestamp('2018-04-03 15:04:49')], [8, Timestamp('2018-04-03 15:09:54'), Timestamp('2018-04-03 15:21:13')], [1, Timestamp('2018-04-03 15:29:04'), Timestamp('2018-04-03 15:39:19')], [1, Timestamp('2018-04-03 15:43:47'), Timestamp('2018-04-03 15:49:16')], [1, Timestamp('2018-04-03 15:56:50'), Timestamp('2018-04-03 15:58:36')], [1, Timestamp('2018-04-03 16:09:51'), Timestamp('2018-04-03 16:19:23')], [1, Timestamp('2018-04-03 16:25:32'), Timestamp('2018-04-03 16:33:28')], [1, Timestamp('2018-04-03 16:44:17'), Timestamp('2018-04-03 16:53:16')], [1, Timestamp('2018-04-03 16:57:36'), Timestamp('2018-04-03 16:57:36')], [1, Timestamp('2018-04-03 17:02:53'), Timestamp('2018-04-03 17:16:35')], [1, Timestamp('2018-04-03 17:22:14'), Timestamp('2018-04-03 17:28:55')], [1, Timestamp('2018-04-03 17:35:13'), Timestamp('2018-04-03 17:43:40')], [1, Timestamp('2018-04-03 17:46:55'), Timestamp('2018-04-03 18:02:00')], [4, Timestamp('2018-04-03 18:35:52'), Timestamp('2018-04-03 18:37:33')], [4, Timestamp('2018-04-03 18:47:37'), Timestamp('2018-04-03 19:20:55')], [4, Timestamp('2018-04-03 19:25:05'), Timestamp('2018-04-03 19:29:07')], [4, Timestamp('2018-04-03 19:35:21'), Timestamp('2018-04-03 20:06:23')], [4, Timestamp('2018-04-03 20:10:50'), Timestamp('2018-04-03 20:31:06')], [5, Timestamp('2018-04-03 20:41:23'), Timestamp('2018-04-03 21:13:06')], [5, Timestamp('2018-04-03 21:16:46'), Timestamp('2018-04-03 21:28:35')], [5, Timestamp('2018-04-03 21:32:01'), Timestamp('2018-04-03 21:38:58')], [5, Timestamp('2018-04-03 21:43:13'), Timestamp('2018-04-03 21:55:19')], [5, Timestamp('2018-04-03 21:59:10'), Timestamp('2018-04-03 22:06:39')], [5, Timestamp('2018-04-03 22:10:41'), Timestamp('2018-04-03 22:26:51')], [9, Timestamp('2018-04-03 22:36:52'), Timestamp('2018-04-03 23:15:54')], [9, Timestamp('2018-04-03 23:22:44'), Timestamp('2018-04-03 23:45:41')], [9, Timestamp('2018-04-03 23:49:01'), Timestamp('2018-04-04 00:06:12')], [9, Timestamp('2018-04-04 00:09:30'), Timestamp('2018-04-04 00:11:30')], [10, Timestamp('2018-04-04 00:36:31'), Timestamp('2018-04-04 00:39:47')], [10, Timestamp('2018-04-04 00:44:06'), Timestamp('2018-04-04 00:56:06')], [10, Timestamp('2018-04-04 01:00:58'), Timestamp('2018-04-04 01:05:43')], [10, Timestamp('2018-04-04 01:35:55'), Timestamp('2018-04-04 02:26:01')], [11, Timestamp('2018-04-04 02:35:36'), Timestamp('2018-04-04 03:07:11')], [11, Timestamp('2018-04-04 03:12:44'), Timestamp('2018-04-04 03:19:30')], [11, Timestamp('2018-04-04 03:23:01'), Timestamp('2018-04-04 03:39:29')], [11, Timestamp('2018-04-04 03:44:17'), Timestamp('2018-04-04 04:09:05')], [11, Timestamp('2018-04-04 04:14:23'), Timestamp('2018-04-04 04:16:24')], [12, Timestamp('2018-04-04 04:38:27'), Timestamp('2018-04-04 04:46:02')], [12, Timestamp('2018-04-04 04:52:50'), Timestamp('2018-04-04 04:56:58')], [12, Timestamp('2018-04-04 05:00:33'), Timestamp('2018-04-04 05:08:06')], [12, Timestamp('2018-04-04 05:14:51'), Timestamp('2018-04-04 05:28:16')], [12, Timestamp('2018-04-04 05:31:17'), Timestamp('2018-04-04 05:36:53')], [12, Timestamp('2018-04-04 05:43:26'), Timestamp('2018-04-04 05:46:17')], [12, Timestamp('2018-04-04 06:01:20'), Timestamp('2018-04-04 06:02:24')], [12, Timestamp('2018-04-04 06:58:48'), Timestamp('2018-04-04 07:02:26')], [12, Timestamp('2018-04-04 07:12:31'), Timestamp('2018-04-04 07:16:38')], [12, Timestamp('2018-04-04 07:23:22'), Timestamp('2018-04-04 07:33:39')], [12, Timestamp('2018-04-04 08:29:09'), Timestamp('2018-04-04 08:29:09')], [12, Timestamp('2018-04-04 08:55:36'), Timestamp('2018-04-04 09:13:08')], [6, Timestamp('2018-04-04 09:38:29'), Timestamp('2018-04-04 09:38:30')], [6, Timestamp('2018-04-04 09:47:57'), Timestamp('2018-04-04 11:21:17')], [7, Timestamp('2018-04-04 12:06:36'), Timestamp('2018-04-04 12:17:14')], [7, Timestamp('2018-04-04 12:25:30'), Timestamp('2018-04-04 12:29:34')], [7, Timestamp('2018-04-04 12:33:04'), Timestamp('2018-04-04 12:34:58')], [7, Timestamp('2018-04-04 13:23:34'), Timestamp('2018-04-04 13:26:24')], [7, Timestamp('2018-04-04 13:29:48'), Timestamp('2018-04-04 13:29:48')], [7, Timestamp('2018-04-04 13:35:19'), Timestamp('2018-04-04 14:24:22')], [7, Timestamp('2018-04-04 14:28:58'), Timestamp('2018-04-04 14:47:10')], [4, Timestamp('2018-04-04 14:59:41'), Timestamp('2018-04-04 15:16:31')], [4, Timestamp('2018-04-04 15:41:34'), Timestamp('2018-04-04 16:00:31')], [4, Timestamp('2018-04-04 16:04:15'), Timestamp('2018-04-04 16:12:38')], [4, Timestamp('2018-04-04 16:15:40'), Timestamp('2018-04-04 16:15:40')], [4, Timestamp('2018-04-04 16:20:10'), Timestamp('2018-04-04 16:24:45')], [4, Timestamp('2018-04-04 16:29:03'), Timestamp('2018-04-04 16:32:02')], [4, Timestamp('2018-04-04 16:35:11'), Timestamp('2018-04-04 16:53:30')], [4, Timestamp('2018-04-04 16:57:02'), Timestamp('2018-04-04 17:02:20')], [4, Timestamp('2018-04-04 17:08:37'), Timestamp('2018-04-04 17:08:37')], [4, Timestamp('2018-04-04 17:12:52'), Timestamp('2018-04-04 17:14:44')], [4, Timestamp('2018-04-04 17:22:03'), Timestamp('2018-04-04 17:22:03')], [4, Timestamp('2018-04-04 17:36:45'), Timestamp('2018-04-04 17:47:23')], [5, Timestamp('2018-04-04 17:59:33'), Timestamp('2018-04-04 17:59:33')], [5, Timestamp('2018-04-04 18:07:17'), Timestamp('2018-04-04 18:22:01')], [5, Timestamp('2018-04-04 18:27:59'), Timestamp('2018-04-04 19:05:39')], [5, Timestamp('2018-04-04 19:13:12'), Timestamp('2018-04-04 19:19:12')], [5, Timestamp('2018-04-04 19:30:39'), Timestamp('2018-04-04 19:38:10')], [5, Timestamp('2018-04-04 19:42:15'), Timestamp('2018-04-04 19:50:58')], [9, Timestamp('2018-04-04 19:57:17'), Timestamp('2018-04-04 20:09:36')], [9, Timestamp('2018-04-04 20:13:07'), Timestamp('2018-04-04 20:18:54')], [9, Timestamp('2018-04-04 20:21:56'), Timestamp('2018-04-04 20:25:20')], [9, Timestamp('2018-04-04 20:34:24'), Timestamp('2018-04-04 20:49:54')], [9, Timestamp('2018-04-04 20:55:20'), Timestamp('2018-04-04 21:14:57')], [11, Timestamp('2018-04-04 21:23:50'), Timestamp('2018-04-04 21:23:50')], [11, Timestamp('2018-04-04 21:28:17'), Timestamp('2018-04-04 21:42:16')], [11, Timestamp('2018-04-04 21:46:19'), Timestamp('2018-04-04 21:54:45')], [11, Timestamp('2018-04-04 21:58:05'), Timestamp('2018-04-04 22:11:20')], [11, Timestamp('2018-04-04 22:15:50'), Timestamp('2018-04-04 22:23:23')], [8, Timestamp('2018-04-04 23:04:35'), Timestamp('2018-04-04 23:15:53')], [8, Timestamp('2018-04-04 23:21:14'), Timestamp('2018-04-04 23:21:59')], [8, Timestamp('2018-04-04 23:25:02'), Timestamp('2018-04-04 23:33:23')], [8, Timestamp('2018-04-04 23:38:08'), Timestamp('2018-04-04 23:45:14')], [8, Timestamp('2018-04-04 23:52:42'), Timestamp('2018-04-04 23:58:29')], [8, Timestamp('2018-04-05 00:02:00'), Timestamp('2018-04-05 00:48:48')], [8, Timestamp('2018-04-05 00:52:15'), Timestamp('2018-04-05 01:03:21')], [1, Timestamp('2018-04-05 01:08:55'), Timestamp('2018-04-05 01:22:23')], [1, Timestamp('2018-04-05 01:28:48'), Timestamp('2018-04-05 01:45:08')], [1, Timestamp('2018-04-05 01:48:52'), Timestamp('2018-04-05 01:50:29')], [1, Timestamp('2018-04-05 01:54:53'), Timestamp('2018-04-05 02:14:10')], [1, Timestamp('2018-04-05 02:18:16'), Timestamp('2018-04-05 02:23:03')], [1, Timestamp('2018-04-05 02:29:42'), Timestamp('2018-04-05 02:39:10')], [2, Timestamp('2018-04-05 02:58:41'), Timestamp('2018-04-05 03:03:04')], [2, Timestamp('2018-04-05 03:06:35'), Timestamp('2018-04-05 03:18:26')], [2, Timestamp('2018-04-05 03:22:35'), Timestamp('2018-04-05 04:00:31')], [2, Timestamp('2018-04-05 04:04:40'), Timestamp('2018-04-05 04:12:16')], [10, Timestamp('2018-04-05 04:28:42'), Timestamp('2018-04-05 04:49:11')], [10, Timestamp('2018-04-05 04:52:13'), Timestamp('2018-04-05 04:52:13')], [10, Timestamp('2018-04-05 04:55:27'), Timestamp('2018-04-05 04:55:27')], [10, Timestamp('2018-04-05 04:58:51'), Timestamp('2018-04-05 04:59:27')], [3, Timestamp('2018-04-05 05:08:01'), Timestamp('2018-04-05 05:57:08')], [3, Timestamp('2018-04-05 06:01:02'), Timestamp('2018-04-05 06:10:23')], [13, Timestamp('2018-04-05 06:23:32'), Timestamp('2018-04-05 07:26:16')], [14, Timestamp('2018-04-05 07:32:30'), Timestamp('2018-04-05 08:26:13')], [14, Timestamp('2018-04-05 20:51:18'), Timestamp('2018-04-05 20:51:31')], [14, Timestamp('2018-04-05 21:09:13'), Timestamp('2018-04-05 21:21:41')], [8, Timestamp('2018-04-05 21:57:05'), Timestamp('2018-04-05 22:05:53')], [8, Timestamp('2018-04-05 22:09:39'), Timestamp('2018-04-05 23:46:28')], [15, Timestamp('2018-04-06 00:02:58'), Timestamp('2018-04-06 00:03:34')], [15, Timestamp('2018-04-06 00:06:38'), Timestamp('2018-04-06 00:32:29')], [15, Timestamp('2018-04-06 00:45:25'), Timestamp('2018-04-06 00:48:50')], [15, Timestamp('2018-04-06 00:52:21'), Timestamp('2018-04-06 00:52:21')], [15, Timestamp('2018-04-06 00:57:35'), Timestamp('2018-04-06 00:57:35')], [16, Timestamp('2018-04-06 01:11:29'), Timestamp('2018-04-06 02:05:33')], [16, Timestamp('2018-04-06 02:09:00'), Timestamp('2018-04-06 02:12:17')], [16, Timestamp('2018-04-06 02:15:31'), Timestamp('2018-04-06 02:27:22')], [1, Timestamp('2018-04-06 02:40:39'), Timestamp('2018-04-06 03:06:40')], [1, Timestamp('2018-04-06 03:10:46'), Timestamp('2018-04-06 03:13:10')], [1, Timestamp('2018-04-06 03:17:02'), Timestamp('2018-04-06 03:22:33')], [1, Timestamp('2018-04-06 03:27:28'), Timestamp('2018-04-06 03:38:34')], [1, Timestamp('2018-04-06 03:42:25'), Timestamp('2018-04-06 04:14:41')], [1, Timestamp('2018-04-06 04:19:02'), Timestamp('2018-04-06 04:19:02')], [1, Timestamp('2018-04-06 04:22:14'), Timestamp('2018-04-06 04:31:45')], [17, Timestamp('2018-04-06 04:35:04'), Timestamp('2018-04-06 04:48:31')], [17, Timestamp('2018-04-06 04:53:19'), Timestamp('2018-04-06 04:53:40')], [17, Timestamp('2018-04-06 05:01:17'), Timestamp('2018-04-06 05:08:20')], [17, Timestamp('2018-04-06 05:13:36'), Timestamp('2018-04-06 05:14:56')], [17, Timestamp('2018-04-06 05:19:14'), Timestamp('2018-04-06 05:22:53')], [18, Timestamp('2018-04-06 05:26:31'), Timestamp('2018-04-06 05:33:09')], [18, Timestamp('2018-04-06 05:38:04'), Timestamp('2018-04-06 06:05:55')], [18, Timestamp('2018-04-06 06:10:28'), Timestamp('2018-04-06 06:27:38')], [8, Timestamp('2018-04-06 06:41:12'), Timestamp('2018-04-06 07:11:42')], [8, Timestamp('2018-04-06 07:16:00'), Timestamp('2018-04-06 07:25:18')], [8, Timestamp('2018-04-06 07:32:05'), Timestamp('2018-04-06 07:36:22')], [8, Timestamp('2018-04-06 07:40:15'), Timestamp('2018-04-06 08:05:10')], [8, Timestamp('2018-04-06 08:09:10'), Timestamp('2018-04-06 08:12:36')], [8, Timestamp('2018-04-06 08:19:53'), Timestamp('2018-04-06 08:46:24')], [1, Timestamp('2018-04-06 09:07:22'), Timestamp('2018-04-06 09:23:54')], [1, Timestamp('2018-04-06 09:29:09'), Timestamp('2018-04-06 09:35:21')], [1, Timestamp('2018-04-06 09:38:22'), Timestamp('2018-04-06 09:56:26')], [1, Timestamp('2018-04-06 10:03:59'), Timestamp('2018-04-06 10:16:01')], [19, Timestamp('2018-04-06 14:13:40'), Timestamp('2018-04-06 14:15:50')], [19, Timestamp('2018-04-06 14:22:36'), Timestamp('2018-04-06 14:26:32')], [20, Timestamp('2018-04-06 16:26:31'), Timestamp('2018-04-06 16:27:27')], [20, Timestamp('2018-04-06 16:32:16'), Timestamp('2018-04-06 16:36:11')], [21, Timestamp('2018-04-06 17:22:06'), Timestamp('2018-04-06 17:34:18')], [21, Timestamp('2018-04-06 17:38:28'), Timestamp('2018-04-06 17:38:28')], [4, Timestamp('2018-04-06 17:51:02'), Timestamp('2018-04-06 18:01:06')], [4, Timestamp('2018-04-06 18:05:22'), Timestamp('2018-04-06 18:05:22')], [4, Timestamp('2018-04-06 18:10:29'), Timestamp('2018-04-06 18:10:29')], [4, Timestamp('2018-04-06 18:14:04'), Timestamp('2018-04-06 18:42:21')], [4, Timestamp('2018-04-06 18:46:06'), Timestamp('2018-04-06 18:50:08')], [4, Timestamp('2018-04-06 19:01:07'), Timestamp('2018-04-06 19:43:17')], [5, Timestamp('2018-04-06 20:04:25'), Timestamp('2018-04-06 20:09:40')], [5, Timestamp('2018-04-06 20:15:34'), Timestamp('2018-04-06 21:43:58')], [9, Timestamp('2018-04-06 22:04:56'), Timestamp('2018-04-06 22:27:01')], [9, Timestamp('2018-04-06 22:33:51'), Timestamp('2018-04-06 22:36:12')], [9, Timestamp('2018-04-06 22:39:25'), Timestamp('2018-04-06 22:42:32')], [9, Timestamp('2018-04-06 22:46:23'), Timestamp('2018-04-06 22:50:12')], [9, Timestamp('2018-04-06 22:56:25'), Timestamp('2018-04-06 23:00:13')], [9, Timestamp('2018-04-06 23:05:12'), Timestamp('2018-04-06 23:12:07')], [9, Timestamp('2018-04-06 23:16:05'), Timestamp('2018-04-06 23:31:25')], [2, Timestamp('2018-04-06 23:36:25'), Timestamp('2018-04-06 23:38:33')], [2, Timestamp('2018-04-06 23:42:14'), Timestamp('2018-04-06 23:45:09')], [2, Timestamp('2018-04-06 23:48:19'), Timestamp('2018-04-07 00:07:52')], [2, Timestamp('2018-04-07 00:13:20'), Timestamp('2018-04-07 00:21:58')], [2, Timestamp('2018-04-07 00:26:36'), Timestamp('2018-04-07 00:35:07')], [2, Timestamp('2018-04-07 00:40:54'), Timestamp('2018-04-07 00:55:52')], [2, Timestamp('2018-04-07 00:59:05'), Timestamp('2018-04-07 01:01:05')], [11, Timestamp('2018-04-07 01:10:35'), Timestamp('2018-04-07 01:10:35')], [11, Timestamp('2018-04-07 01:14:14'), Timestamp('2018-04-07 01:42:01')], [11, Timestamp('2018-04-07 01:45:50'), Timestamp('2018-04-07 02:12:09')], [11, Timestamp('2018-04-07 02:15:16'), Timestamp('2018-04-07 02:18:23')], [3, Timestamp('2018-04-07 02:23:31'), Timestamp('2018-04-07 02:31:20')], [3, Timestamp('2018-04-07 02:35:31'), Timestamp('2018-04-07 02:44:25')], [3, Timestamp('2018-04-07 02:48:41'), Timestamp('2018-04-07 02:54:41')], [3, Timestamp('2018-04-07 02:58:01'), Timestamp('2018-04-07 03:20:34')], [3, Timestamp('2018-04-07 03:23:39'), Timestamp('2018-04-07 03:23:39')], [3, Timestamp('2018-04-07 03:30:53'), Timestamp('2018-04-07 03:35:57')], [3, Timestamp('2018-04-07 03:39:26'), Timestamp('2018-04-07 03:40:51')], [6, Timestamp('2018-04-07 04:14:04'), Timestamp('2018-04-07 04:31:50')], [6, Timestamp('2018-04-07 04:36:09'), Timestamp('2018-04-07 05:18:12')], [6, Timestamp('2018-04-07 05:22:08'), Timestamp('2018-04-07 05:30:37')], [6, Timestamp('2018-04-07 05:37:56'), Timestamp('2018-04-07 05:54:22')], [7, Timestamp('2018-04-07 06:11:28'), Timestamp('2018-04-07 06:31:25')], [7, Timestamp('2018-04-07 06:38:20'), Timestamp('2018-04-07 08:07:23')], [16, Timestamp('2018-04-07 08:55:27'), Timestamp('2018-04-07 09:44:04')], [16, Timestamp('2018-04-07 09:48:25'), Timestamp('2018-04-07 09:49:15')], [8, Timestamp('2018-04-07 09:53:13'), Timestamp('2018-04-07 10:06:27')], [8, Timestamp('2018-04-07 10:10:08'), Timestamp('2018-04-07 10:14:17')], [8, Timestamp('2018-04-07 10:17:42'), Timestamp('2018-04-07 11:26:48')], [8, Timestamp('2018-04-07 11:44:11'), Timestamp('2018-04-07 12:07:56')], [18, Timestamp('2018-04-07 12:10:13'), Timestamp('2018-04-07 12:51:55')], [1, Timestamp('2018-04-07 13:12:19'), Timestamp('2018-04-07 13:22:18')], [1, Timestamp('2018-04-07 13:25:28'), Timestamp('2018-04-07 13:40:25')], [1, Timestamp('2018-04-07 13:44:07'), Timestamp('2018-04-07 14:07:42')], [1, Timestamp('2018-04-07 14:13:12'), Timestamp('2018-04-07 14:19:22')], [1, Timestamp('2018-04-07 14:24:39'), Timestamp('2018-04-07 15:05:49')], [1, Timestamp('2018-04-07 15:10:28'), Timestamp('2018-04-07 15:15:09')], [4, Timestamp('2018-04-07 15:34:01'), Timestamp('2018-04-07 16:30:30')], [4, Timestamp('2018-04-07 16:36:46'), Timestamp('2018-04-07 17:16:28')], [9, Timestamp('2018-04-07 17:20:05'), Timestamp('2018-04-07 17:20:05')], [9, Timestamp('2018-04-07 17:25:09'), Timestamp('2018-04-07 17:28:17')], [9, Timestamp('2018-04-07 17:34:58'), Timestamp('2018-04-07 17:40:50')], [9, Timestamp('2018-04-07 17:50:51'), Timestamp('2018-04-07 17:58:48')], [9, Timestamp('2018-04-07 18:02:03'), Timestamp('2018-04-07 18:26:46')], [9, Timestamp('2018-04-07 18:34:03'), Timestamp('2018-04-07 18:39:22')], [9, Timestamp('2018-04-07 18:42:35'), Timestamp('2018-04-07 18:44:30')], [5, Timestamp('2018-04-07 18:56:30'), Timestamp('2018-04-07 19:15:14')], [5, Timestamp('2018-04-07 19:19:14'), Timestamp('2018-04-07 19:26:37')], [5, Timestamp('2018-04-07 19:32:56'), Timestamp('2018-04-07 19:41:37')], [5, Timestamp('2018-04-07 19:48:16'), Timestamp('2018-04-07 19:49:51')], [5, Timestamp('2018-04-07 19:53:06'), Timestamp('2018-04-07 20:38:17')], [11, Timestamp('2018-04-07 20:42:47'), Timestamp('2018-04-07 21:03:11')], [11, Timestamp('2018-04-07 21:06:30'), Timestamp('2018-04-07 21:35:46')], [11, Timestamp('2018-04-07 21:39:36'), Timestamp('2018-04-07 21:46:13')], [2, Timestamp('2018-04-07 23:33:09'), Timestamp('2018-04-07 23:38:58')], [2, Timestamp('2018-04-07 23:42:13'), Timestamp('2018-04-07 23:42:13')], [2, Timestamp('2018-04-07 23:46:16'), Timestamp('2018-04-08 00:27:03')], [2, Timestamp('2018-04-08 00:32:19'), Timestamp('2018-04-08 00:46:20')], [4, Timestamp('2018-04-08 00:52:52'), Timestamp('2018-04-08 01:32:55')], [4, Timestamp('2018-04-08 01:36:24'), Timestamp('2018-04-08 02:14:11')], [4, Timestamp('2018-04-08 02:19:55'), Timestamp('2018-04-08 02:23:23')], [3, Timestamp('2018-04-08 02:30:31'), Timestamp('2018-04-08 02:31:18')], [3, Timestamp('2018-04-08 02:37:24'), Timestamp('2018-04-08 02:42:54')], [3, Timestamp('2018-04-08 02:46:47'), Timestamp('2018-04-08 03:10:35')], [3, Timestamp('2018-04-08 03:14:38'), Timestamp('2018-04-08 03:22:49')], [3, Timestamp('2018-04-08 03:31:11'), Timestamp('2018-04-08 03:35:50')], [3, Timestamp('2018-04-08 03:45:09'), Timestamp('2018-04-08 03:47:54')], [3, Timestamp('2018-04-08 03:51:07'), Timestamp('2018-04-08 04:04:45')], [5, Timestamp('2018-04-08 04:11:46'), Timestamp('2018-04-08 05:37:11')], [5, Timestamp('2018-04-08 05:40:20'), Timestamp('2018-04-08 05:41:25')], [4, Timestamp('2018-04-08 05:46:03'), Timestamp('2018-04-08 06:16:39')], [4, Timestamp('2018-04-08 06:19:51'), Timestamp('2018-04-08 06:24:59')], [4, Timestamp('2018-04-08 06:32:24'), Timestamp('2018-04-08 06:44:58')], [4, Timestamp('2018-04-08 06:50:35'), Timestamp('2018-04-08 06:53:42')], [4, Timestamp('2018-04-08 06:59:36'), Timestamp('2018-04-08 07:44:48')], [4, Timestamp('2018-04-08 07:49:23'), Timestamp('2018-04-08 07:58:44')], [4, Timestamp('2018-04-08 08:03:08'), Timestamp('2018-04-08 08:16:56')], [5, Timestamp('2018-04-08 08:19:18'), Timestamp('2018-04-08 08:31:20')], [5, Timestamp('2018-04-08 08:37:31'), Timestamp('2018-04-08 08:38:59')], [5, Timestamp('2018-04-08 08:44:59'), Timestamp('2018-04-08 08:51:59')], [5, Timestamp('2018-04-08 08:58:12'), Timestamp('2018-04-08 09:16:48')], [5, Timestamp('2018-04-08 09:22:02'), Timestamp('2018-04-08 09:55:37')], [5, Timestamp('2018-04-08 10:00:53'), Timestamp('2018-04-08 10:12:45')], [5, Timestamp('2018-04-08 10:17:25'), Timestamp('2018-04-08 10:18:56')], [5, Timestamp('2018-04-08 10:22:33'), Timestamp('2018-04-08 10:26:14')], [5, Timestamp('2018-04-08 10:29:34'), Timestamp('2018-04-08 10:34:11')], [4, Timestamp('2018-04-08 10:40:53'), Timestamp('2018-04-08 10:42:20')], [4, Timestamp('2018-04-08 10:46:27'), Timestamp('2018-04-08 11:28:21')], [4, Timestamp('2018-04-08 11:33:28'), Timestamp('2018-04-08 11:46:11')], [4, Timestamp('2018-04-08 11:52:27'), Timestamp('2018-04-08 12:18:13')], [5, Timestamp('2018-04-08 12:33:15'), Timestamp('2018-04-08 12:41:27')], [5, Timestamp('2018-04-08 12:45:12'), Timestamp('2018-04-08 13:07:34')], [5, Timestamp('2018-04-08 13:45:34'), Timestamp('2018-04-08 13:59:42')], [4, Timestamp('2018-04-08 14:43:15'), Timestamp('2018-04-08 14:43:15')], [4, Timestamp('2018-04-08 14:47:44'), Timestamp('2018-04-08 15:08:20')], [4, Timestamp('2018-04-08 15:11:32'), Timestamp('2018-04-08 15:18:31')], [4, Timestamp('2018-04-08 15:21:36'), Timestamp('2018-04-08 15:45:33')], [4, Timestamp('2018-04-08 15:51:05'), Timestamp('2018-04-08 16:09:05')], [9, Timestamp('2018-04-08 16:11:24'), Timestamp('2018-04-08 16:28:15')], [9, Timestamp('2018-04-08 16:32:11'), Timestamp('2018-04-08 16:48:56')], [9, Timestamp('2018-04-08 16:58:29'), Timestamp('2018-04-08 17:32:38')], [5, Timestamp('2018-04-08 17:41:17'), Timestamp('2018-04-08 18:58:17')], [5, Timestamp('2018-04-08 19:02:29'), Timestamp('2018-04-08 19:14:43')], [5, Timestamp('2018-04-08 19:21:56'), Timestamp('2018-04-08 19:47:28')], [5, Timestamp('2018-04-08 19:52:32'), Timestamp('2018-04-08 19:52:32')], [11, Timestamp('2018-04-08 20:04:36'), Timestamp('2018-04-08 20:28:31')], [11, Timestamp('2018-04-08 20:32:33'), Timestamp('2018-04-08 21:18:11')], [4, Timestamp('2018-04-08 21:28:54'), Timestamp('2018-04-08 21:34:22')], [4, Timestamp('2018-04-08 21:38:26'), Timestamp('2018-04-08 21:58:31')], [4, Timestamp('2018-04-09 05:59:55'), Timestamp('2018-04-09 06:07:57')], [4, Timestamp('2018-04-09 06:11:49'), Timestamp('2018-04-09 06:36:09')], [4, Timestamp('2018-04-09 06:41:01'), Timestamp('2018-04-09 06:44:23')], [4, Timestamp('2018-04-09 06:48:57'), Timestamp('2018-04-09 07:12:40')], [5, Timestamp('2018-04-09 07:23:34'), Timestamp('2018-04-09 07:23:34')], [5, Timestamp('2018-04-09 07:30:47'), Timestamp('2018-04-09 07:35:34')], [5, Timestamp('2018-04-09 07:39:04'), Timestamp('2018-04-09 07:46:37')], [5, Timestamp('2018-04-09 07:49:41'), Timestamp('2018-04-09 08:46:21')], [5, Timestamp('2018-04-09 08:50:01'), Timestamp('2018-04-09 09:06:56')], [16, Timestamp('2018-04-09 09:46:21'), Timestamp('2018-04-09 10:30:57')], [16, Timestamp('2018-04-09 10:34:53'), Timestamp('2018-04-09 11:22:24')], [16, Timestamp('2018-04-09 11:25:51'), Timestamp('2018-04-09 11:45:19')], [18, Timestamp('2018-04-09 11:54:53'), Timestamp('2018-04-09 12:34:33')], [18, Timestamp('2018-04-09 12:39:23'), Timestamp('2018-04-09 12:42:03')], [18, Timestamp('2018-04-09 12:47:43'), Timestamp('2018-04-09 12:50:21')], [18, Timestamp('2018-04-09 13:19:28'), Timestamp('2018-04-09 13:19:28')], [18, Timestamp('2018-04-09 13:23:50'), Timestamp('2018-04-09 13:23:50')], [18, Timestamp('2018-04-09 13:30:31'), Timestamp('2018-04-09 13:38:57')], [18, Timestamp('2018-04-09 13:42:37'), Timestamp('2018-04-09 14:10:51')], [8, Timestamp('2018-04-09 14:23:16'), Timestamp('2018-04-09 16:08:53')], [1, Timestamp('2018-04-09 16:11:25'), Timestamp('2018-04-09 16:51:21')], [1, Timestamp('2018-04-09 16:57:22'), Timestamp('2018-04-09 17:02:55')], [1, Timestamp('2018-04-09 17:06:01'), Timestamp('2018-04-09 17:27:48')], [1, Timestamp('2018-04-09 17:33:13'), Timestamp('2018-04-09 17:39:46')], [1, Timestamp('2018-04-09 17:43:40'), Timestamp('2018-04-09 17:50:06')], [19, Timestamp('2018-04-09 18:36:56'), Timestamp('2018-04-09 19:13:34')], [19, Timestamp('2018-04-09 19:22:38'), Timestamp('2018-04-09 19:54:22')], [19, Timestamp('2018-04-09 19:58:00'), Timestamp('2018-04-09 20:35:51')], [19, Timestamp('2018-04-09 20:39:48'), Timestamp('2018-04-09 20:48:20')], [19, Timestamp('2018-04-09 20:55:44'), Timestamp('2018-04-09 21:33:29')], [21, Timestamp('2018-04-09 21:46:33'), Timestamp('2018-04-09 21:52:47')], [21, Timestamp('2018-04-09 22:05:07'), Timestamp('2018-04-09 22:42:54')], [21, Timestamp('2018-04-09 22:45:56'), Timestamp('2018-04-09 22:49:39')], [21, Timestamp('2018-04-09 22:52:56'), Timestamp('2018-04-09 22:55:17')], [21, Timestamp('2018-04-09 22:58:51'), Timestamp('2018-04-09 23:49:59')], [21, Timestamp('2018-04-10 00:13:38'), Timestamp('2018-04-10 00:16:45')], [21, Timestamp('2018-04-10 00:20:17'), Timestamp('2018-04-10 01:02:16')], [21, Timestamp('2018-04-10 01:26:47'), Timestamp('2018-04-10 01:37:50')], [2, Timestamp('2018-04-10 01:58:20'), Timestamp('2018-04-10 02:52:20')], [2, Timestamp('2018-04-10 02:56:58'), Timestamp('2018-04-10 03:00:13')], [2, Timestamp('2018-04-10 03:03:41'), Timestamp('2018-04-10 03:11:30')], [2, Timestamp('2018-04-10 03:16:03'), Timestamp('2018-04-10 03:16:40')], [2, Timestamp('2018-04-10 03:20:43'), Timestamp('2018-04-10 03:36:56')], [2, Timestamp('2018-04-10 03:40:37'), Timestamp('2018-04-10 03:49:08')], [3, Timestamp('2018-04-10 03:53:18'), Timestamp('2018-04-10 04:28:41')], [3, Timestamp('2018-04-10 04:31:55'), Timestamp('2018-04-10 05:33:36')], [6, Timestamp('2018-04-10 05:59:57'), Timestamp('2018-04-10 06:12:48')], [6, Timestamp('2018-04-10 06:16:19'), Timestamp('2018-04-10 06:39:11')], [6, Timestamp('2018-04-10 06:46:04'), Timestamp('2018-04-10 06:58:54')], [6, Timestamp('2018-04-10 07:07:01'), Timestamp('2018-04-10 07:10:42')], [6, Timestamp('2018-04-10 07:14:20'), Timestamp('2018-04-10 07:19:19')], [6, Timestamp('2018-04-10 07:22:26'), Timestamp('2018-04-10 07:39:16')], [6, Timestamp('2018-04-10 07:44:12'), Timestamp('2018-04-10 08:06:48')], [6, Timestamp('2018-04-10 08:17:23'), Timestamp('2018-04-10 08:21:48')], [6, Timestamp('2018-04-10 08:26:22'), Timestamp('2018-04-10 08:28:01')], [7, Timestamp('2018-04-10 08:47:33'), Timestamp('2018-04-10 08:48:09')], [7, Timestamp('2018-04-10 08:54:56'), Timestamp('2018-04-10 09:34:50')], [7, Timestamp('2018-04-10 09:43:16'), Timestamp('2018-04-10 10:37:01')], [7, Timestamp('2018-04-10 10:40:06'), Timestamp('2018-04-10 10:48:21')], [7, Timestamp('2018-04-10 10:51:27'), Timestamp('2018-04-10 10:58:16')], [10, Timestamp('2018-04-10 11:28:00'), Timestamp('2018-04-10 11:29:38')], [10, Timestamp('2018-04-10 11:35:13'), Timestamp('2018-04-10 11:38:57')], [10, Timestamp('2018-04-10 11:43:25'), Timestamp('2018-04-10 12:12:58')], [10, Timestamp('2018-04-10 12:16:01'), Timestamp('2018-04-10 12:41:42')], [10, Timestamp('2018-04-10 13:01:27'), Timestamp('2018-04-10 13:38:14')], [12, Timestamp('2018-04-10 14:07:42'), Timestamp('2018-04-10 14:08:29')], [12, Timestamp('2018-04-10 14:15:57'), Timestamp('2018-04-10 14:29:35')], [12, Timestamp('2018-04-10 14:34:16'), Timestamp('2018-04-10 14:42:07')], [12, Timestamp('2018-04-10 14:46:46'), Timestamp('2018-04-10 14:54:11')], [12, Timestamp('2018-04-10 15:03:04'), Timestamp('2018-04-10 15:05:06')], [12, Timestamp('2018-04-10 15:09:16'), Timestamp('2018-04-10 15:25:02')], [12, Timestamp('2018-04-10 15:28:08'), Timestamp('2018-04-10 15:28:08')], [12, Timestamp('2018-04-10 15:33:20'), Timestamp('2018-04-10 15:34:41')], [12, Timestamp('2018-04-10 15:40:46'), Timestamp('2018-04-10 16:09:55')], [12, Timestamp('2018-04-10 16:13:30'), Timestamp('2018-04-10 16:16:38')], [12, Timestamp('2018-04-10 16:23:11'), Timestamp('2018-04-10 16:23:11')], [12, Timestamp('2018-04-10 16:27:53'), Timestamp('2018-04-10 16:37:27')], [12, Timestamp('2018-04-10 16:47:53'), Timestamp('2018-04-10 16:50:31')], [12, Timestamp('2018-04-10 16:56:32'), Timestamp('2018-04-10 16:56:32')], [12, Timestamp('2018-04-10 17:00:37'), Timestamp('2018-04-10 17:10:55')], [12, Timestamp('2018-04-10 17:14:24'), Timestamp('2018-04-10 17:20:03')], [12, Timestamp('2018-04-10 17:23:57'), Timestamp('2018-04-10 17:31:59')], [12, Timestamp('2018-04-10 17:35:33'), Timestamp('2018-04-10 17:42:37')], [12, Timestamp('2018-04-10 17:46:35'), Timestamp('2018-04-10 17:59:17')], [8, Timestamp('2018-04-10 18:26:52'), Timestamp('2018-04-10 20:10:00')], [1, Timestamp('2018-04-10 20:20:31'), Timestamp('2018-04-10 20:32:57')], [1, Timestamp('2018-04-10 20:36:17'), Timestamp('2018-04-10 20:54:32')], [1, Timestamp('2018-04-10 20:57:33'), Timestamp('2018-04-10 21:43:56')], [16, Timestamp('2018-04-10 21:55:04'), Timestamp('2018-04-10 22:00:01')], [16, Timestamp('2018-04-10 22:05:52'), Timestamp('2018-04-10 23:10:42')], [18, Timestamp('2018-04-10 23:14:50'), Timestamp('2018-04-11 00:06:48')], [2, Timestamp('2018-04-11 00:33:18'), Timestamp('2018-04-11 00:33:18')], [2, Timestamp('2018-04-11 00:37:00'), Timestamp('2018-04-11 00:41:23')], [2, Timestamp('2018-04-11 00:46:04'), Timestamp('2018-04-11 01:02:21')], [2, Timestamp('2018-04-11 01:06:10'), Timestamp('2018-04-11 01:42:06')], [13, Timestamp('2018-04-11 01:48:34'), Timestamp('2018-04-11 02:27:16')], [13, Timestamp('2018-04-11 02:30:37'), Timestamp('2018-04-11 02:35:50')], [13, Timestamp('2018-04-11 02:40:13'), Timestamp('2018-04-11 02:49:34')], [13, Timestamp('2018-04-11 02:52:42'), Timestamp('2018-04-11 02:58:28')], [3, Timestamp('2018-04-11 03:06:36'), Timestamp('2018-04-11 03:48:50')], [3, Timestamp('2018-04-11 03:55:02'), Timestamp('2018-04-11 03:59:13')], [3, Timestamp('2018-04-11 04:02:41'), Timestamp('2018-04-11 04:10:05')], [3, Timestamp('2018-04-11 04:16:07'), Timestamp('2018-04-11 04:16:28')], [14, Timestamp('2018-04-11 04:20:18'), Timestamp('2018-04-11 04:26:43')], [14, Timestamp('2018-04-11 04:30:47'), Timestamp('2018-04-11 05:29:14')], [4, Timestamp('2018-04-11 05:33:49'), Timestamp('2018-04-11 05:48:31')], [4, Timestamp('2018-04-11 05:52:20'), Timestamp('2018-04-11 06:21:33')], [4, Timestamp('2018-04-11 06:27:43'), Timestamp('2018-04-11 06:31:35')], [4, Timestamp('2018-04-11 06:35:24'), Timestamp('2018-04-11 06:43:20')], [4, Timestamp('2018-04-11 06:49:05'), Timestamp('2018-04-11 07:07:02')], [4, Timestamp('2018-04-11 07:12:19'), Timestamp('2018-04-11 07:20:04')], [5, Timestamp('2018-04-11 07:21:57'), Timestamp('2018-04-11 07:28:13')], [5, Timestamp('2018-04-11 07:33:37'), Timestamp('2018-04-11 08:35:26')], [5, Timestamp('2018-04-11 08:48:37'), Timestamp('2018-04-11 09:12:51')], [4, Timestamp('2018-04-11 09:19:30'), Timestamp('2018-04-11 09:35:39')], [4, Timestamp('2018-04-11 09:39:45'), Timestamp('2018-04-11 10:23:54')], [4, Timestamp('2018-04-11 10:32:33'), Timestamp('2018-04-11 10:57:42')], [4, Timestamp('2018-04-11 11:04:49'), Timestamp('2018-04-11 11:05:45')], [4, Timestamp('2018-04-11 11:11:13'), Timestamp('2018-04-11 11:13:37')], [5, Timestamp('2018-04-11 11:27:55'), Timestamp('2018-04-11 12:23:34')], [5, Timestamp('2018-04-11 12:27:14'), Timestamp('2018-04-11 13:17:00')], [9, Timestamp('2018-04-11 13:27:01'), Timestamp('2018-04-11 14:33:15')], [9, Timestamp('2018-04-11 14:36:34'), Timestamp('2018-04-11 14:40:24')], [11, Timestamp('2018-04-11 14:53:15'), Timestamp('2018-04-11 15:50:33')], [11, Timestamp('2018-04-11 15:54:10'), Timestamp('2018-04-11 16:10:00')], [6, Timestamp('2018-04-11 16:22:20'), Timestamp('2018-04-11 16:27:55')], [6, Timestamp('2018-04-11 16:33:54'), Timestamp('2018-04-11 16:44:43')], [6, Timestamp('2018-04-11 16:49:51'), Timestamp('2018-04-11 17:11:52')], [6, Timestamp('2018-04-11 17:15:13'), Timestamp('2018-04-11 17:41:08')], [6, Timestamp('2018-04-11 17:48:07'), Timestamp('2018-04-11 18:45:41')], [6, Timestamp('2018-04-11 18:48:51'), Timestamp('2018-04-11 18:56:07')], [7, Timestamp('2018-04-11 19:10:44'), Timestamp('2018-04-11 19:38:39')], [7, Timestamp('2018-04-11 19:45:17'), Timestamp('2018-04-11 20:07:00')], [7, Timestamp('2018-04-11 20:13:33'), Timestamp('2018-04-11 20:44:55')], [7, Timestamp('2018-04-11 20:49:09'), Timestamp('2018-04-11 20:58:31')], [7, Timestamp('2018-04-11 21:01:32'), Timestamp('2018-04-11 21:07:34')], [7, Timestamp('2018-04-11 21:14:40'), Timestamp('2018-04-11 21:39:17')], [7, Timestamp('2018-04-11 21:42:37'), Timestamp('2018-04-11 21:45:32')], [7, Timestamp('2018-04-11 21:48:34'), Timestamp('2018-04-11 22:06:14')], [10, Timestamp('2018-04-11 22:20:31'), Timestamp('2018-04-11 23:25:41')], [10, Timestamp('2018-04-11 23:29:26'), Timestamp('2018-04-11 23:32:53')], [10, Timestamp('2018-04-11 23:39:39'), Timestamp('2018-04-11 23:42:44')], [12, Timestamp('2018-04-12 00:02:35'), Timestamp('2018-04-12 00:04:40')], [12, Timestamp('2018-04-12 00:21:06'), Timestamp('2018-04-12 00:21:06')], [12, Timestamp('2018-04-12 00:25:17'), Timestamp('2018-04-12 01:10:37')], [12, Timestamp('2018-04-12 01:13:46'), Timestamp('2018-04-12 01:20:59')], [12, Timestamp('2018-04-12 01:24:11'), Timestamp('2018-04-12 01:29:02')], [12, Timestamp('2018-04-12 01:33:03'), Timestamp('2018-04-12 01:37:06')], [12, Timestamp('2018-04-12 01:41:09'), Timestamp('2018-04-12 01:55:43')], [8, Timestamp('2018-04-12 02:25:42'), Timestamp('2018-04-12 02:51:49')], [8, Timestamp('2018-04-12 02:55:17'), Timestamp('2018-04-12 02:59:08')], [8, Timestamp('2018-04-12 03:02:12'), Timestamp('2018-04-12 03:17:14')], [8, Timestamp('2018-04-12 03:23:39'), Timestamp('2018-04-12 03:24:36')], [8, Timestamp('2018-04-12 03:29:32'), Timestamp('2018-04-12 03:37:32')], [8, Timestamp('2018-04-12 03:40:47'), Timestamp('2018-04-12 03:56:08')], [8, Timestamp('2018-04-12 03:59:40'), Timestamp('2018-04-12 04:01:31')], [8, Timestamp('2018-04-12 04:06:17'), Timestamp('2018-04-12 04:13:11')], [8, Timestamp('2018-04-12 04:19:04'), Timestamp('2018-04-12 04:44:02')], [1, Timestamp('2018-04-12 04:55:01'), Timestamp('2018-04-12 05:23:11')], [1, Timestamp('2018-04-12 05:26:31'), Timestamp('2018-04-12 05:30:30')], [1, Timestamp('2018-04-12 05:38:52'), Timestamp('2018-04-12 05:39:18')], [1, Timestamp('2018-04-12 05:43:29'), Timestamp('2018-04-12 06:29:08')], [1, Timestamp('2018-04-12 06:34:36'), Timestamp('2018-04-12 06:39:02')], [8, Timestamp('2018-04-12 06:58:06'), Timestamp('2018-04-12 07:00:41')], [8, Timestamp('2018-04-12 07:05:31'), Timestamp('2018-04-12 07:25:24')], [8, Timestamp('2018-04-12 07:44:11'), Timestamp('2018-04-12 07:50:40')], [8, Timestamp('2018-04-12 07:57:38'), Timestamp('2018-04-12 07:57:38')], [8, Timestamp('2018-04-12 08:03:04'), Timestamp('2018-04-12 08:25:18')], [8, Timestamp('2018-04-12 11:43:30'), Timestamp('2018-04-12 11:44:00')], [8, Timestamp('2018-04-12 11:48:06'), Timestamp('2018-04-12 11:48:06')], [8, Timestamp('2018-04-12 12:05:11'), Timestamp('2018-04-12 12:11:06')], [8, Timestamp('2018-04-12 12:16:10'), Timestamp('2018-04-12 12:16:10')], [8, Timestamp('2018-04-12 12:20:56'), Timestamp('2018-04-12 12:27:19')], [8, Timestamp('2018-04-12 12:31:58'), Timestamp('2018-04-12 12:31:58')], [8, Timestamp('2018-04-12 12:42:12'), Timestamp('2018-04-12 12:45:46')], [8, Timestamp('2018-04-12 12:49:51'), Timestamp('2018-04-12 13:01:03')], [8, Timestamp('2018-04-12 13:19:20'), Timestamp('2018-04-12 13:25:52')], [8, Timestamp('2018-04-12 13:39:47'), Timestamp('2018-04-12 13:40:39')], [1, Timestamp('2018-04-12 13:43:36'), Timestamp('2018-04-12 13:44:07')], [1, Timestamp('2018-04-12 13:51:19'), Timestamp('2018-04-12 13:53:10')], [1, Timestamp('2018-04-12 14:34:59'), Timestamp('2018-04-12 14:34:59')], [8, Timestamp('2018-04-12 14:35:18'), Timestamp('2018-04-12 14:35:18')], [1, Timestamp('2018-04-12 14:35:57'), Timestamp('2018-04-12 14:37:43')], [1, Timestamp('2018-04-12 14:41:34'), Timestamp('2018-04-12 14:51:23')], [1, Timestamp('2018-04-12 14:55:07'), Timestamp('2018-04-12 15:21:13')], [1, Timestamp('2018-04-12 15:27:32'), Timestamp('2018-04-12 15:27:56')], [1, Timestamp('2018-04-12 15:52:39'), Timestamp('2018-04-12 15:56:41')], [1, Timestamp('2018-04-12 16:02:28'), Timestamp('2018-04-12 16:35:20')], [1, Timestamp('2018-04-12 16:40:35'), Timestamp('2018-04-12 16:56:31')], [4, Timestamp('2018-04-12 17:29:57'), Timestamp('2018-04-12 18:47:11')], [4, Timestamp('2018-04-12 18:52:48'), Timestamp('2018-04-12 20:06:37')], [4, Timestamp('2018-04-12 20:10:45'), Timestamp('2018-04-12 20:15:33')], [5, Timestamp('2018-04-12 20:23:04'), Timestamp('2018-04-12 21:14:51')], [5, Timestamp('2018-04-12 21:18:06'), Timestamp('2018-04-12 21:23:23')], [5, Timestamp('2018-04-12 21:26:51'), Timestamp('2018-04-12 21:28:25')], [5, Timestamp('2018-04-12 21:32:40'), Timestamp('2018-04-12 22:16:48')], [5, Timestamp('2018-04-12 22:19:56'), Timestamp('2018-04-12 22:37:57')], [5, Timestamp('2018-04-12 22:45:45'), Timestamp('2018-04-12 23:19:52')], [5, Timestamp('2018-04-12 23:23:17'), Timestamp('2018-04-12 23:23:17')], [2, Timestamp('2018-04-12 23:32:32'), Timestamp('2018-04-13 00:12:34')], [2, Timestamp('2018-04-13 00:16:54'), Timestamp('2018-04-13 00:16:54')], [2, Timestamp('2018-04-13 00:20:05'), Timestamp('2018-04-13 00:41:16')], [2, Timestamp('2018-04-13 00:44:45'), Timestamp('2018-04-13 00:56:33')], [2, Timestamp('2018-04-13 01:01:24'), Timestamp('2018-04-13 01:06:11')], [2, Timestamp('2018-04-13 01:09:14'), Timestamp('2018-04-13 01:15:11')], [2, Timestamp('2018-04-13 01:18:53'), Timestamp('2018-04-13 01:31:12')], [3, Timestamp('2018-04-13 01:34:43'), Timestamp('2018-04-13 01:45:46')], [3, Timestamp('2018-04-13 01:50:43'), Timestamp('2018-04-13 02:23:52')], [3, Timestamp('2018-04-13 02:30:34'), Timestamp('2018-04-13 03:00:15')], [3, Timestamp('2018-04-13 03:03:35'), Timestamp('2018-04-13 03:09:42')], [3, Timestamp('2018-04-13 03:12:46'), Timestamp('2018-04-13 03:18:38')], [22, Timestamp('2018-04-13 03:57:59'), Timestamp('2018-04-13 04:35:03')], [22, Timestamp('2018-04-13 04:38:11'), Timestamp('2018-04-13 05:01:17')], [8, Timestamp('2018-04-13 05:05:21'), Timestamp('2018-04-13 06:24:04')], [8, Timestamp('2018-04-13 06:29:02'), Timestamp('2018-04-13 06:53:02')], [23, Timestamp('2018-04-13 07:01:38'), Timestamp('2018-04-13 07:11:11')], [23, Timestamp('2018-04-13 07:17:23'), Timestamp('2018-04-13 07:44:57')], [23, Timestamp('2018-04-13 07:48:23'), Timestamp('2018-04-13 08:12:21')], [1, Timestamp('2018-04-13 08:44:07'), Timestamp('2018-04-13 08:50:02')], [1, Timestamp('2018-04-13 08:53:07'), Timestamp('2018-04-13 09:12:41')], [1, Timestamp('2018-04-13 09:15:45'), Timestamp('2018-04-13 09:38:33')], [1, Timestamp('2018-04-13 09:45:32'), Timestamp('2018-04-13 10:13:45')], [17, Timestamp('2018-04-13 10:26:09'), Timestamp('2018-04-13 10:26:09')], [1, Timestamp('2018-04-13 10:27:01'), Timestamp('2018-04-13 10:27:01')], [8, Timestamp('2018-04-13 10:42:47'), Timestamp('2018-04-13 10:42:47')], [8, Timestamp('2018-04-13 10:48:29'), Timestamp('2018-04-13 11:01:17')], [8, Timestamp('2018-04-13 11:06:48'), Timestamp('2018-04-13 11:29:09')], [8, Timestamp('2018-04-13 11:34:51'), Timestamp('2018-04-13 11:59:25')], [8, Timestamp('2018-04-13 12:02:44'), Timestamp('2018-04-13 12:29:18')], [8, Timestamp('2018-04-13 12:34:11'), Timestamp('2018-04-13 12:45:57')], [8, Timestamp('2018-04-13 12:49:09'), Timestamp('2018-04-13 12:53:31')], [1, Timestamp('2018-04-13 12:55:27'), Timestamp('2018-04-13 12:55:27')], [1, Timestamp('2018-04-13 12:58:32'), Timestamp('2018-04-13 13:06:04')], [1, Timestamp('2018-04-13 13:10:08'), Timestamp('2018-04-13 13:23:13')], [1, Timestamp('2018-04-13 13:26:15'), Timestamp('2018-04-13 13:35:52')], [1, Timestamp('2018-04-13 13:40:23'), Timestamp('2018-04-13 13:59:10')], [1, Timestamp('2018-04-13 14:05:13'), Timestamp('2018-04-13 14:13:34')], [1, Timestamp('2018-04-13 14:20:24'), Timestamp('2018-04-13 14:27:35')], [1, Timestamp('2018-04-13 14:32:15'), Timestamp('2018-04-13 14:44:25')], [1, Timestamp('2018-04-13 14:49:13'), Timestamp('2018-04-13 14:49:41')], [6, Timestamp('2018-04-13 15:21:15'), Timestamp('2018-04-13 15:30:22')], [6, Timestamp('2018-04-13 15:33:25'), Timestamp('2018-04-13 15:38:47')], [6, Timestamp('2018-04-13 15:47:31'), Timestamp('2018-04-13 15:50:52')], [6, Timestamp('2018-04-13 15:55:21'), Timestamp('2018-04-13 15:59:11')], [6, Timestamp('2018-04-13 16:04:27'), Timestamp('2018-04-13 16:47:20')], [6, Timestamp('2018-04-13 16:54:52'), Timestamp('2018-04-13 16:56:40')], [6, Timestamp('2018-04-13 17:01:58'), Timestamp('2018-04-13 17:08:21')], [6, Timestamp('2018-04-13 17:12:45'), Timestamp('2018-04-13 17:15:16')], [6, Timestamp('2018-04-13 17:23:25'), Timestamp('2018-04-13 17:32:43')], [24, Timestamp('2018-04-13 17:38:02'), Timestamp('2018-04-13 18:10:20')], [24, Timestamp('2018-04-13 18:14:14'), Timestamp('2018-04-13 18:33:14')], [24, Timestamp('2018-04-13 18:38:32'), Timestamp('2018-04-13 19:26:06')], [7, Timestamp('2018-04-13 19:39:56'), Timestamp('2018-04-13 20:46:33')], [7, Timestamp('2018-04-13 20:49:45'), Timestamp('2018-04-13 21:20:39')], [25, Timestamp('2018-04-13 21:31:15'), Timestamp('2018-04-13 22:23:38')], [25, Timestamp('2018-04-13 22:28:35'), Timestamp('2018-04-13 23:19:23')], [10, Timestamp('2018-04-13 23:30:45'), Timestamp('2018-04-14 00:08:23')], [10, Timestamp('2018-04-14 00:15:07'), Timestamp('2018-04-14 00:34:07')], [10, Timestamp('2018-04-14 00:37:49'), Timestamp('2018-04-14 00:37:49')], [10, Timestamp('2018-04-14 00:44:09'), Timestamp('2018-04-14 00:50:16')], [10, Timestamp('2018-04-14 00:54:54'), Timestamp('2018-04-14 00:58:32')], [12, Timestamp('2018-04-14 01:13:18'), Timestamp('2018-04-14 01:16:01')], [12, Timestamp('2018-04-14 01:20:56'), Timestamp('2018-04-14 01:23:32')], [12, Timestamp('2018-04-14 01:27:00'), Timestamp('2018-04-14 01:27:00')], [12, Timestamp('2018-04-14 01:30:15'), Timestamp('2018-04-14 01:32:12')], [12, Timestamp('2018-04-14 01:36:59'), Timestamp('2018-04-14 01:50:16')], [12, Timestamp('2018-04-14 01:56:33'), Timestamp('2018-04-14 02:24:49')], [12, Timestamp('2018-04-14 02:29:48'), Timestamp('2018-04-14 02:31:43')], [12, Timestamp('2018-04-14 02:53:36'), Timestamp('2018-04-14 03:00:14')], [12, Timestamp('2018-04-14 03:05:35'), Timestamp('2018-04-14 03:10:31')], [12, Timestamp('2018-04-14 03:15:04'), Timestamp('2018-04-14 03:15:04')], [12, Timestamp('2018-04-14 03:31:19'), Timestamp('2018-04-14 03:34:07')], [13, Timestamp('2018-04-14 03:48:32'), Timestamp('2018-04-14 04:21:58')], [13, Timestamp('2018-04-14 04:35:57'), Timestamp('2018-04-14 04:42:14')], [13, Timestamp('2018-04-14 04:53:08'), Timestamp('2018-04-14 04:57:27')], [13, Timestamp('2018-04-14 05:00:36'), Timestamp('2018-04-14 05:37:30')], [13, Timestamp('2018-04-14 05:42:09'), Timestamp('2018-04-14 05:42:44')], [13, Timestamp('2018-04-14 05:46:30'), Timestamp('2018-04-14 05:56:53')], [14, Timestamp('2018-04-14 06:04:07'), Timestamp('2018-04-14 06:24:01')], [14, Timestamp('2018-04-14 06:37:57'), Timestamp('2018-04-14 06:48:40')], [14, Timestamp('2018-04-14 06:53:14'), Timestamp('2018-04-14 07:25:39')], [14, Timestamp('2018-04-14 07:29:59'), Timestamp('2018-04-14 07:36:02')], [14, Timestamp('2018-04-14 07:42:05'), Timestamp('2018-04-14 07:59:13')], [4, Timestamp('2018-04-14 08:14:32'), Timestamp('2018-04-14 08:37:25')], [4, Timestamp('2018-04-14 08:44:03'), Timestamp('2018-04-14 08:56:34')], [4, Timestamp('2018-04-14 09:00:51'), Timestamp('2018-04-14 09:33:52')], [4, Timestamp('2018-04-14 09:39:05'), Timestamp('2018-04-14 09:46:11')], [4, Timestamp('2018-04-14 09:49:24'), Timestamp('2018-04-14 09:53:08')], [5, Timestamp('2018-04-14 10:12:37'), Timestamp('2018-04-14 10:13:55')], [5, Timestamp('2018-04-14 10:18:01'), Timestamp('2018-04-14 10:24:42')], [5, Timestamp('2018-04-14 10:29:03'), Timestamp('2018-04-14 10:49:39')], [5, Timestamp('2018-04-14 10:54:14'), Timestamp('2018-04-14 10:59:38')], [5, Timestamp('2018-04-14 11:03:09'), Timestamp('2018-04-14 11:11:04')], [5, Timestamp('2018-04-14 11:14:56'), Timestamp('2018-04-14 11:25:46')], [5, Timestamp('2018-04-14 11:31:25'), Timestamp('2018-04-14 11:46:16')], [5, Timestamp('2018-04-14 11:53:49'), Timestamp('2018-04-14 12:04:32')], [5, Timestamp('2018-04-14 12:14:32'), Timestamp('2018-04-14 12:18:05')], [4, Timestamp('2018-04-14 12:22:23'), Timestamp('2018-04-14 12:49:53')], [4, Timestamp('2018-04-14 12:53:46'), Timestamp('2018-04-14 13:16:41')], [4, Timestamp('2018-04-14 13:22:46'), Timestamp('2018-04-14 13:39:04')], [4, Timestamp('2018-04-14 13:43:45'), Timestamp('2018-04-14 14:06:08')], [5, Timestamp('2018-04-14 14:08:43'), Timestamp('2018-04-14 14:12:37')], [5, Timestamp('2018-04-14 14:15:48'), Timestamp('2018-04-14 15:05:49')], [5, Timestamp('2018-04-14 15:10:01'), Timestamp('2018-04-14 16:02:42')], [5, Timestamp('2018-04-14 16:05:47'), Timestamp('2018-04-14 16:05:47')], [9, Timestamp('2018-04-14 16:08:05'), Timestamp('2018-04-14 16:34:24')], [9, Timestamp('2018-04-14 16:40:47'), Timestamp('2018-04-14 16:46:14')], [9, Timestamp('2018-04-14 16:50:37'), Timestamp('2018-04-14 16:58:02')], [9, Timestamp('2018-04-14 17:06:01'), Timestamp('2018-04-14 17:12:27')], [9, Timestamp('2018-04-14 17:18:49'), Timestamp('2018-04-14 17:21:45')], [11, Timestamp('2018-04-14 17:25:31'), Timestamp('2018-04-14 18:25:42')], [6, Timestamp('2018-04-14 18:36:53'), Timestamp('2018-04-14 19:16:15')], [6, Timestamp('2018-04-14 19:19:26'), Timestamp('2018-04-14 19:30:37')], [6, Timestamp('2018-04-14 19:38:26'), Timestamp('2018-04-14 19:42:40')], [6, Timestamp('2018-04-14 19:45:41'), Timestamp('2018-04-14 19:55:59')], [6, Timestamp('2018-04-14 20:02:26'), Timestamp('2018-04-14 20:03:47')], [6, Timestamp('2018-04-14 20:09:44'), Timestamp('2018-04-14 20:09:44')], [6, Timestamp('2018-04-14 20:15:58'), Timestamp('2018-04-14 20:35:13')], [7, Timestamp('2018-04-14 20:36:57'), Timestamp('2018-04-14 20:41:32')], [7, Timestamp('2018-04-14 20:47:38'), Timestamp('2018-04-14 22:21:48')], [7, Timestamp('2018-04-14 22:27:19'), Timestamp('2018-04-14 22:29:40')], [19, Timestamp('2018-04-14 23:08:28'), Timestamp('2018-04-14 23:28:46')], [19, Timestamp('2018-04-14 23:31:47'), Timestamp('2018-04-14 23:31:47')], [19, Timestamp('2018-04-14 23:35:15'), Timestamp('2018-04-14 23:35:15')], [8, Timestamp('2018-04-14 23:55:34'), Timestamp('2018-04-15 01:39:48')], [1, Timestamp('2018-04-15 01:46:43'), Timestamp('2018-04-15 02:10:21')], [1, Timestamp('2018-04-15 02:15:29'), Timestamp('2018-04-15 02:24:29')], [1, Timestamp('2018-04-15 02:29:00'), Timestamp('2018-04-15 03:15:18')], [21, Timestamp('2018-04-15 03:56:39'), Timestamp('2018-04-15 03:56:53')], [21, Timestamp('2018-04-15 04:01:27'), Timestamp('2018-04-15 04:02:57')], [21, Timestamp('2018-04-15 04:07:03'), Timestamp('2018-04-15 04:15:07')], [21, Timestamp('2018-04-15 04:18:11'), Timestamp('2018-04-15 04:40:59')], [21, Timestamp('2018-04-15 04:45:45'), Timestamp('2018-04-15 04:50:00')], [19, Timestamp('2018-04-15 04:56:51'), Timestamp('2018-04-15 05:00:32')], [19, Timestamp('2018-04-15 05:04:52'), Timestamp('2018-04-15 06:07:31')], [21, Timestamp('2018-04-15 06:22:35'), Timestamp('2018-04-15 06:52:53')], [21, Timestamp('2018-04-15 06:56:15'), Timestamp('2018-04-15 06:58:52')], [21, Timestamp('2018-04-15 07:04:19'), Timestamp('2018-04-15 07:42:39')], [16, Timestamp('2018-04-15 07:48:54'), Timestamp('2018-04-15 08:10:19')], [16, Timestamp('2018-04-15 08:13:58'), Timestamp('2018-04-15 08:20:06')], [16, Timestamp('2018-04-15 08:25:27'), Timestamp('2018-04-15 08:39:55')], [16, Timestamp('2018-04-15 08:44:45'), Timestamp('2018-04-15 09:40:49')], [16, Timestamp('2018-04-15 09:45:38'), Timestamp('2018-04-15 09:56:41')], [16, Timestamp('2018-04-15 10:03:12'), Timestamp('2018-04-15 10:13:50')], [16, Timestamp('2018-04-15 10:17:06'), Timestamp('2018-04-15 10:17:06')], [18, Timestamp('2018-04-15 10:18:06'), Timestamp('2018-04-15 10:47:46')], [18, Timestamp('2018-04-15 10:53:21'), Timestamp('2018-04-15 11:03:09')], [18, Timestamp('2018-04-15 11:09:28'), Timestamp('2018-04-15 11:18:16')], [18, Timestamp('2018-04-15 11:24:59'), Timestamp('2018-04-15 11:39:49')], [18, Timestamp('2018-04-15 11:53:38'), Timestamp('2018-04-15 11:58:41')], [18, Timestamp('2018-04-15 12:03:46'), Timestamp('2018-04-15 12:06:34')], [18, Timestamp('2018-04-15 12:12:54'), Timestamp('2018-04-15 12:17:03')], [18, Timestamp('2018-04-15 12:24:38'), Timestamp('2018-04-15 12:25:43')], [18, Timestamp('2018-04-15 12:29:49'), Timestamp('2018-04-15 12:38:41')], [16, Timestamp('2018-04-15 12:43:29'), Timestamp('2018-04-15 13:51:56')], [16, Timestamp('2018-04-15 13:56:20'), Timestamp('2018-04-15 14:04:47')], [16, Timestamp('2018-04-15 14:10:00'), Timestamp('2018-04-15 15:04:36')], [16, Timestamp('2018-04-15 15:09:54'), Timestamp('2018-04-15 15:20:26')], [18, Timestamp('2018-04-15 15:23:01'), Timestamp('2018-04-15 15:33:22')], [18, Timestamp('2018-04-15 15:38:10'), Timestamp('2018-04-15 15:41:51')], [18, Timestamp('2018-04-15 15:45:39'), Timestamp('2018-04-15 15:46:35')], [18, Timestamp('2018-04-15 15:58:28'), Timestamp('2018-04-15 16:21:58')], [18, Timestamp('2018-04-15 16:27:52'), Timestamp('2018-04-15 16:30:36')], [18, Timestamp('2018-04-15 16:36:58'), Timestamp('2018-04-15 16:48:17')], [18, Timestamp('2018-04-15 16:52:01'), Timestamp('2018-04-15 17:43:46')], [10, Timestamp('2018-04-15 18:00:14'), Timestamp('2018-04-15 18:05:03')], [10, Timestamp('2018-04-15 18:11:23'), Timestamp('2018-04-15 18:37:57')], [10, Timestamp('2018-04-15 18:43:39'), Timestamp('2018-04-15 18:43:39')], [10, Timestamp('2018-04-15 18:48:02'), Timestamp('2018-04-15 19:50:22')], [10, Timestamp('2018-04-15 19:56:23'), Timestamp('2018-04-15 19:56:23')], [10, Timestamp('2018-04-15 20:12:53'), Timestamp('2018-04-15 20:52:44')], [12, Timestamp('2018-04-15 21:06:40'), Timestamp('2018-04-15 21:08:00')], [12, Timestamp('2018-04-15 21:12:23'), Timestamp('2018-04-15 21:19:52')], [12, Timestamp('2018-04-15 21:23:53'), Timestamp('2018-04-15 21:33:17')], [12, Timestamp('2018-04-15 21:37:10'), Timestamp('2018-04-15 21:39:53')], [12, Timestamp('2018-04-15 21:44:14'), Timestamp('2018-04-15 22:01:44')], [12, Timestamp('2018-04-15 22:05:56'), Timestamp('2018-04-15 22:07:37')], [12, Timestamp('2018-04-15 22:10:50'), Timestamp('2018-04-15 22:14:54')], [12, Timestamp('2018-04-15 22:18:46'), Timestamp('2018-04-15 22:20:54')], [12, Timestamp('2018-04-15 22:40:17'), Timestamp('2018-04-15 22:52:52')], [12, Timestamp('2018-04-15 22:58:29'), Timestamp('2018-04-15 23:00:44')], [12, Timestamp('2018-04-15 23:05:25'), Timestamp('2018-04-15 23:10:54')], [12, Timestamp('2018-04-15 23:14:55'), Timestamp('2018-04-15 23:36:10')], [12, Timestamp('2018-04-15 23:39:28'), Timestamp('2018-04-15 23:41:08')], [12, Timestamp('2018-04-15 23:44:51'), Timestamp('2018-04-15 23:48:18')], [12, Timestamp('2018-04-15 23:52:09'), Timestamp('2018-04-16 00:07:12')], [12, Timestamp('2018-04-16 00:11:22'), Timestamp('2018-04-16 00:11:22')], [12, Timestamp('2018-04-16 00:26:31'), Timestamp('2018-04-16 00:28:42')], [12, Timestamp('2018-04-16 00:35:58'), Timestamp('2018-04-16 00:35:58')], [12, Timestamp('2018-04-16 00:39:21'), Timestamp('2018-04-16 00:53:45')], [12, Timestamp('2018-04-16 00:59:01'), Timestamp('2018-04-16 01:06:32')], [12, Timestamp('2018-04-16 01:12:02'), Timestamp('2018-04-16 01:12:49')], [12, Timestamp('2018-04-16 01:18:27'), Timestamp('2018-04-16 01:36:07')], [4, Timestamp('2018-04-16 01:47:50'), Timestamp('2018-04-16 01:52:55')], [4, Timestamp('2018-04-16 01:56:34'), Timestamp('2018-04-16 01:59:12')], [4, Timestamp('2018-04-16 02:03:22'), Timestamp('2018-04-16 02:05:08')], [4, Timestamp('2018-04-16 02:08:19'), Timestamp('2018-04-16 02:42:02')], [4, Timestamp('2018-04-16 02:45:34'), Timestamp('2018-04-16 02:56:55')], [4, Timestamp('2018-04-16 03:05:01'), Timestamp('2018-04-16 03:06:39')], [4, Timestamp('2018-04-16 03:09:58'), Timestamp('2018-04-16 03:15:28')], [4, Timestamp('2018-04-16 03:23:34'), Timestamp('2018-04-16 03:41:22')], [4, Timestamp('2018-04-16 03:44:46'), Timestamp('2018-04-16 04:10:00')], [4, Timestamp('2018-04-16 04:14:32'), Timestamp('2018-04-16 04:22:25')], [4, Timestamp('2018-04-16 04:26:38'), Timestamp('2018-04-16 04:49:05')], [4, Timestamp('2018-04-16 04:53:26'), Timestamp('2018-04-16 04:59:00')], [4, Timestamp('2018-04-16 05:02:21'), Timestamp('2018-04-16 05:02:52')], [4, Timestamp('2018-04-16 05:07:25'), Timestamp('2018-04-16 05:13:24')], [4, Timestamp('2018-04-16 05:18:00'), Timestamp('2018-04-16 05:23:19')], [5, Timestamp('2018-04-16 05:29:21'), Timestamp('2018-04-16 05:33:35')], [5, Timestamp('2018-04-16 05:37:10'), Timestamp('2018-04-16 06:13:51')], [5, Timestamp('2018-04-16 06:18:09'), Timestamp('2018-04-16 06:52:48')], [5, Timestamp('2018-04-16 07:04:50'), Timestamp('2018-04-16 07:42:26')], [5, Timestamp('2018-04-16 07:49:02'), Timestamp('2018-04-16 08:01:40')], [5, Timestamp('2018-04-16 08:08:26'), Timestamp('2018-04-16 08:32:13')], [5, Timestamp('2018-04-16 08:36:34'), Timestamp('2018-04-16 08:58:05')], [2, Timestamp('2018-04-16 09:02:14'), Timestamp('2018-04-16 09:15:36')], [2, Timestamp('2018-04-16 09:18:46'), Timestamp('2018-04-16 09:38:01')], [2, Timestamp('2018-04-16 09:41:03'), Timestamp('2018-04-16 09:52:37')], [2, Timestamp('2018-04-16 09:59:59'), Timestamp('2018-04-16 10:12:09')], [2, Timestamp('2018-04-16 10:18:10'), Timestamp('2018-04-16 10:21:45')], [4, Timestamp('2018-04-16 10:24:13'), Timestamp('2018-04-16 10:31:40')], [4, Timestamp('2018-04-16 10:35:39'), Timestamp('2018-04-16 11:20:47')], [4, Timestamp('2018-04-16 11:26:06'), Timestamp('2018-04-16 11:26:06')], [3, Timestamp('2018-04-16 11:28:41'), Timestamp('2018-04-16 11:32:54')], [3, Timestamp('2018-04-16 11:37:06'), Timestamp('2018-04-16 11:42:18')], [3, Timestamp('2018-04-16 11:46:46'), Timestamp('2018-04-16 12:09:19')], [3, Timestamp('2018-04-16 12:12:25'), Timestamp('2018-04-16 12:15:29')], [3, Timestamp('2018-04-16 12:19:10'), Timestamp('2018-04-16 12:28:46')], [3, Timestamp('2018-04-16 12:43:17'), Timestamp('2018-04-16 13:03:41')], [5, Timestamp('2018-04-16 13:05:29'), Timestamp('2018-04-16 13:38:52')], [5, Timestamp('2018-04-16 13:44:24'), Timestamp('2018-04-16 13:58:56')], [5, Timestamp('2018-04-16 14:02:05'), Timestamp('2018-04-16 14:08:10')], [20, Timestamp('2018-04-16 15:06:42'), Timestamp('2018-04-16 15:06:42')], [20, Timestamp('2018-04-16 15:13:44'), Timestamp('2018-04-16 15:13:44')], [20, Timestamp('2018-04-16 15:17:27'), Timestamp('2018-04-16 15:19:29')], [20, Timestamp('2018-04-16 15:23:19'), Timestamp('2018-04-16 16:44:32')], [20, Timestamp('2018-04-16 16:58:35'), Timestamp('2018-04-16 17:05:14')], [20, Timestamp('2018-04-16 17:08:17'), Timestamp('2018-04-16 17:16:08')], [20, Timestamp('2018-04-16 17:26:24'), Timestamp('2018-04-16 17:50:30')], [20, Timestamp('2018-04-16 17:53:43'), Timestamp('2018-04-16 17:56:29')], [20, Timestamp('2018-04-16 17:59:36'), Timestamp('2018-04-16 17:59:36')], [20, Timestamp('2018-04-16 18:02:40'), Timestamp('2018-04-16 18:41:24')], [20, Timestamp('2018-04-16 18:46:08'), Timestamp('2018-04-16 19:16:16')], [20, Timestamp('2018-04-16 19:21:59'), Timestamp('2018-04-16 19:35:58')], [8, Timestamp('2018-04-16 19:55:56'), Timestamp('2018-04-16 20:37:04')], [8, Timestamp('2018-04-16 20:40:05'), Timestamp('2018-04-16 21:01:10')], [8, Timestamp('2018-04-16 21:07:46'), Timestamp('2018-04-16 21:09:25')], [1, Timestamp('2018-04-16 21:27:09'), Timestamp('2018-04-16 21:40:36')], [1, Timestamp('2018-04-16 21:43:41'), Timestamp('2018-04-16 22:08:53')], [1, Timestamp('2018-04-16 22:12:46'), Timestamp('2018-04-16 22:26:45')], [8, Timestamp('2018-04-16 22:30:52'), Timestamp('2018-04-16 23:46:09')], [8, Timestamp('2018-04-16 23:52:33'), Timestamp('2018-04-17 00:20:32')], [1, Timestamp('2018-04-17 00:22:27'), Timestamp('2018-04-17 00:28:00')], [1, Timestamp('2018-04-17 00:34:14'), Timestamp('2018-04-17 00:35:37')], [1, Timestamp('2018-04-17 00:42:02'), Timestamp('2018-04-17 00:48:24')], [1, Timestamp('2018-04-17 00:55:39'), Timestamp('2018-04-17 02:00:48')], [6, Timestamp('2018-04-17 02:35:01'), Timestamp('2018-04-17 02:46:14')], [6, Timestamp('2018-04-17 02:51:38'), Timestamp('2018-04-17 03:05:53')], [6, Timestamp('2018-04-17 03:12:21'), Timestamp('2018-04-17 03:17:26')], [6, Timestamp('2018-04-17 03:28:07'), Timestamp('2018-04-17 03:38:02')], [6, Timestamp('2018-04-17 03:41:23'), Timestamp('2018-04-17 03:47:11')], [6, Timestamp('2018-04-17 03:51:30'), Timestamp('2018-04-17 03:54:14')], [6, Timestamp('2018-04-17 03:59:13'), Timestamp('2018-04-17 03:59:13')], [6, Timestamp('2018-04-17 04:03:03'), Timestamp('2018-04-17 04:23:15')], [6, Timestamp('2018-04-17 04:28:31'), Timestamp('2018-04-17 04:38:08')], [6, Timestamp('2018-04-17 04:43:15'), Timestamp('2018-04-17 04:43:15')], [6, Timestamp('2018-04-17 04:48:49'), Timestamp('2018-04-17 04:48:49')], [7, Timestamp('2018-04-17 04:49:47'), Timestamp('2018-04-17 05:01:47')], [7, Timestamp('2018-04-17 05:05:49'), Timestamp('2018-04-17 05:07:18')], [7, Timestamp('2018-04-17 05:14:54'), Timestamp('2018-04-17 05:29:47')], [7, Timestamp('2018-04-17 05:32:55'), Timestamp('2018-04-17 05:56:49')], [7, Timestamp('2018-04-17 06:00:08'), Timestamp('2018-04-17 06:00:48')], [7, Timestamp('2018-04-17 06:16:03'), Timestamp('2018-04-17 07:01:49')], [6, Timestamp('2018-04-17 07:03:40'), Timestamp('2018-04-17 07:17:38')], [6, Timestamp('2018-04-17 07:21:04'), Timestamp('2018-04-17 07:38:54')], [6, Timestamp('2018-04-17 07:45:14'), Timestamp('2018-04-17 07:45:55')], [6, Timestamp('2018-04-17 07:50:22'), Timestamp('2018-04-17 07:58:51')], [6, Timestamp('2018-04-17 08:15:17'), Timestamp('2018-04-17 08:17:05')], [6, Timestamp('2018-04-17 08:22:23'), Timestamp('2018-04-17 08:40:03')], [6, Timestamp('2018-04-17 08:43:40'), Timestamp('2018-04-17 08:47:32')], [6, Timestamp('2018-04-17 08:55:43'), Timestamp('2018-04-17 09:06:14')], [7, Timestamp('2018-04-17 09:14:03'), Timestamp('2018-04-17 09:23:37')], [7, Timestamp('2018-04-17 09:27:55'), Timestamp('2018-04-17 09:41:08')], [7, Timestamp('2018-04-17 09:44:26'), Timestamp('2018-04-17 09:54:47')], [7, Timestamp('2018-04-17 09:58:12'), Timestamp('2018-04-17 10:15:53')], [7, Timestamp('2018-04-17 10:21:22'), Timestamp('2018-04-17 10:50:06')], [4, Timestamp('2018-04-17 11:01:29'), Timestamp('2018-04-17 11:20:41')], [4, Timestamp('2018-04-17 11:24:25'), Timestamp('2018-04-17 11:35:55')], [4, Timestamp('2018-04-17 11:43:45'), Timestamp('2018-04-17 11:47:16')], [4, Timestamp('2018-04-17 11:54:23'), Timestamp('2018-04-17 12:09:43')], [4, Timestamp('2018-04-17 12:14:34'), Timestamp('2018-04-17 12:26:08')], [4, Timestamp('2018-04-17 12:30:15'), Timestamp('2018-04-17 13:06:43')], [4, Timestamp('2018-04-17 13:11:53'), Timestamp('2018-04-17 13:15:21')], [4, Timestamp('2018-04-17 13:18:38'), Timestamp('2018-04-17 13:23:33')], [4, Timestamp('2018-04-17 13:27:46'), Timestamp('2018-04-17 13:30:26')], [5, Timestamp('2018-04-17 13:43:38'), Timestamp('2018-04-17 13:54:21')], [5, Timestamp('2018-04-17 13:59:15'), Timestamp('2018-04-17 14:00:38')], [5, Timestamp('2018-04-17 14:04:45'), Timestamp('2018-04-17 14:04:45')], [5, Timestamp('2018-04-17 14:09:37'), Timestamp('2018-04-17 14:49:19')], [5, Timestamp('2018-04-17 14:53:17'), Timestamp('2018-04-17 15:33:38')], [5, Timestamp('2018-04-17 16:53:04'), Timestamp('2018-04-17 17:13:52')], [4, Timestamp('2018-04-17 17:18:48'), Timestamp('2018-04-17 17:41:38')], [4, Timestamp('2018-04-17 17:45:05'), Timestamp('2018-04-17 19:17:22')], [4, Timestamp('2018-04-17 19:20:42'), Timestamp('2018-04-17 19:27:12')], [5, Timestamp('2018-04-17 19:29:46'), Timestamp('2018-04-17 19:45:51')], [5, Timestamp('2018-04-17 19:49:42'), Timestamp('2018-04-17 20:32:41')], [5, Timestamp('2018-04-17 20:36:14'), Timestamp('2018-04-17 20:41:58')], [5, Timestamp('2018-04-17 20:47:18'), Timestamp('2018-04-17 20:54:53')], [5, Timestamp('2018-04-17 21:02:36'), Timestamp('2018-04-17 21:55:31')], [2, Timestamp('2018-04-17 22:06:11'), Timestamp('2018-04-17 22:06:11')], [2, Timestamp('2018-04-17 22:11:48'), Timestamp('2018-04-17 22:11:48')], [2, Timestamp('2018-04-17 22:14:49'), Timestamp('2018-04-17 22:24:52')], [2, Timestamp('2018-04-17 22:30:19'), Timestamp('2018-04-17 22:37:02')], [2, Timestamp('2018-04-17 22:42:19'), Timestamp('2018-04-17 23:03:33')], [2, Timestamp('2018-04-17 23:07:09'), Timestamp('2018-04-17 23:12:51')], [2, Timestamp('2018-04-17 23:18:33'), Timestamp('2018-04-17 23:28:30')], [3, Timestamp('2018-04-17 23:33:49'), Timestamp('2018-04-17 23:41:36')], [3, Timestamp('2018-04-17 23:46:59'), Timestamp('2018-04-18 00:01:57')], [3, Timestamp('2018-04-18 00:05:19'), Timestamp('2018-04-18 00:37:38')], [3, Timestamp('2018-04-18 00:42:31'), Timestamp('2018-04-18 00:47:05')], [6, Timestamp('2018-04-18 01:06:26'), Timestamp('2018-04-18 01:10:06')], [6, Timestamp('2018-04-18 01:14:12'), Timestamp('2018-04-18 01:33:10')], [6, Timestamp('2018-04-18 01:37:59'), Timestamp('2018-04-18 02:17:43')], [6, Timestamp('2018-04-18 02:22:43'), Timestamp('2018-04-18 02:28:44')], [6, Timestamp('2018-04-18 02:34:33'), Timestamp('2018-04-18 02:42:16')], [6, Timestamp('2018-04-18 02:45:35'), Timestamp('2018-04-18 02:55:22')], [7, Timestamp('2018-04-18 03:04:03'), Timestamp('2018-04-18 03:32:05')], [7, Timestamp('2018-04-18 03:39:36'), Timestamp('2018-04-18 04:02:49')], [7, Timestamp('2018-04-18 04:06:14'), Timestamp('2018-04-18 04:15:54')], [7, Timestamp('2018-04-18 04:19:07'), Timestamp('2018-04-18 05:03:30')], [7, Timestamp('2018-04-18 05:10:03'), Timestamp('2018-04-18 05:10:03')], [8, Timestamp('2018-04-18 05:38:26'), Timestamp('2018-04-18 05:43:58')], [8, Timestamp('2018-04-18 05:48:25'), Timestamp('2018-04-18 05:58:03')], [8, Timestamp('2018-04-18 06:03:50'), Timestamp('2018-04-18 06:06:20')], [8, Timestamp('2018-04-18 06:16:49'), Timestamp('2018-04-18 06:22:03')], [8, Timestamp('2018-04-18 06:26:47'), Timestamp('2018-04-18 06:27:38')], [8, Timestamp('2018-04-18 06:31:33'), Timestamp('2018-04-18 06:41:06')], [8, Timestamp('2018-04-18 06:44:42'), Timestamp('2018-04-18 07:37:19')], [8, Timestamp('2018-04-18 07:42:27'), Timestamp('2018-04-18 07:48:21')], [8, Timestamp('2018-04-18 07:53:23'), Timestamp('2018-04-18 08:16:41')], [8, Timestamp('2018-04-18 08:19:46'), Timestamp('2018-04-18 08:20:43')], [1, Timestamp('2018-04-18 08:34:25'), Timestamp('2018-04-18 08:34:25')], [1, Timestamp('2018-04-18 08:37:28'), Timestamp('2018-04-18 09:11:35')], [1, Timestamp('2018-04-18 09:15:39'), Timestamp('2018-04-18 09:22:21')], [1, Timestamp('2018-04-18 09:50:33'), Timestamp('2018-04-18 09:53:33')], [1, Timestamp('2018-04-18 09:57:22'), Timestamp('2018-04-18 10:20:44')], [1, Timestamp('2018-04-18 10:23:46'), Timestamp('2018-04-18 10:34:57')], [1, Timestamp('2018-04-18 10:40:59'), Timestamp('2018-04-18 10:47:49')], [1, Timestamp('2018-04-18 10:52:24'), Timestamp('2018-04-18 10:58:16')], [1, Timestamp('2018-04-18 12:01:20'), Timestamp('2018-04-18 12:02:27')], [4, Timestamp('2018-04-18 12:18:37'), Timestamp('2018-04-18 12:19:16')], [4, Timestamp('2018-04-18 12:30:27'), Timestamp('2018-04-18 12:30:27')], [4, Timestamp('2018-04-18 12:36:17'), Timestamp('2018-04-18 12:49:12')], [4, Timestamp('2018-04-18 12:53:13'), Timestamp('2018-04-18 13:32:39')], [4, Timestamp('2018-04-18 13:35:55'), Timestamp('2018-04-18 14:04:36')], [4, Timestamp('2018-04-18 14:11:28'), Timestamp('2018-04-18 14:14:40')], [4, Timestamp('2018-04-18 14:18:56'), Timestamp('2018-04-18 14:20:07')], [4, Timestamp('2018-04-18 14:24:55'), Timestamp('2018-04-18 14:59:22')], [4, Timestamp('2018-04-18 15:03:30'), Timestamp('2018-04-18 15:19:21')], [4, Timestamp('2018-04-18 15:22:46'), Timestamp('2018-04-18 15:24:31')], [4, Timestamp('2018-04-18 15:29:59'), Timestamp('2018-04-18 15:57:03')], [5, Timestamp('2018-04-18 16:10:01'), Timestamp('2018-04-18 16:39:47')], [5, Timestamp('2018-04-18 16:50:24'), Timestamp('2018-04-18 16:57:47')], [5, Timestamp('2018-04-18 17:01:15'), Timestamp('2018-04-18 17:02:30')], [5, Timestamp('2018-04-18 17:07:53'), Timestamp('2018-04-18 17:16:17')], [5, Timestamp('2018-04-18 17:19:31'), Timestamp('2018-04-18 17:20:11')], [5, Timestamp('2018-04-18 17:26:00'), Timestamp('2018-04-18 17:35:12')], [5, Timestamp('2018-04-18 17:39:09'), Timestamp('2018-04-18 17:42:38')], [5, Timestamp('2018-04-18 17:45:50'), Timestamp('2018-04-18 18:07:31')], [5, Timestamp('2018-04-18 18:11:53'), Timestamp('2018-04-18 18:17:18')], [5, Timestamp('2018-04-18 18:20:46'), Timestamp('2018-04-18 18:32:19')], [5, Timestamp('2018-04-18 18:39:31'), Timestamp('2018-04-18 19:22:06')], [5, Timestamp('2018-04-18 19:25:32'), Timestamp('2018-04-18 19:33:14')], [5, Timestamp('2018-04-18 19:38:12'), Timestamp('2018-04-18 19:47:08')], [10, Timestamp('2018-04-18 20:30:15'), Timestamp('2018-04-18 21:31:01')], [10, Timestamp('2018-04-18 21:35:02'), Timestamp('2018-04-18 22:01:18')], [12, Timestamp('2018-04-18 22:17:09'), Timestamp('2018-04-18 22:20:54')], [12, Timestamp('2018-04-18 22:26:10'), Timestamp('2018-04-18 22:27:33')], [12, Timestamp('2018-04-18 22:33:03'), Timestamp('2018-04-18 22:45:42')], [12, Timestamp('2018-04-18 22:49:06'), Timestamp('2018-04-18 22:49:40')], [12, Timestamp('2018-04-18 22:56:46'), Timestamp('2018-04-18 23:12:48')], [12, Timestamp('2018-04-18 23:16:09'), Timestamp('2018-04-18 23:38:17')], [12, Timestamp('2018-04-18 23:41:30'), Timestamp('2018-04-19 00:10:24')], [12, Timestamp('2018-04-19 00:19:51'), Timestamp('2018-04-19 00:28:59')], [12, Timestamp('2018-04-19 00:35:24'), Timestamp('2018-04-19 00:39:25')], [12, Timestamp('2018-04-19 00:47:15'), Timestamp('2018-04-19 00:59:29')], [12, Timestamp('2018-04-19 01:02:32'), Timestamp('2018-04-19 01:02:32')], [8, Timestamp('2018-04-19 01:16:17'), Timestamp('2018-04-19 01:50:04')], [8, Timestamp('2018-04-19 01:54:16'), Timestamp('2018-04-19 01:54:16')], [8, Timestamp('2018-04-19 01:57:24'), Timestamp('2018-04-19 02:06:06')], [8, Timestamp('2018-04-19 02:09:23'), Timestamp('2018-04-19 02:57:37')], [8, Timestamp('2018-04-19 03:01:49'), Timestamp('2018-04-19 03:04:28')], [8, Timestamp('2018-04-19 03:08:20'), Timestamp('2018-04-19 03:51:25')], [1, Timestamp('2018-04-19 04:12:06'), Timestamp('2018-04-19 04:22:34')], [1, Timestamp('2018-04-19 04:26:24'), Timestamp('2018-04-19 04:40:27')], [1, Timestamp('2018-04-19 04:48:44'), Timestamp('2018-04-19 05:04:34')], [1, Timestamp('2018-04-19 05:08:13'), Timestamp('2018-04-19 05:14:21')], [1, Timestamp('2018-04-19 05:17:46'), Timestamp('2018-04-19 05:22:25')], [1, Timestamp('2018-04-19 05:26:39'), Timestamp('2018-04-19 05:49:15')], [1, Timestamp('2018-04-19 05:52:53'), Timestamp('2018-04-19 06:03:56')], [1, Timestamp('2018-04-19 06:13:50'), Timestamp('2018-04-19 06:29:24')], [8, Timestamp('2018-04-19 06:35:05'), Timestamp('2018-04-19 06:52:44')], [8, Timestamp('2018-04-19 06:58:54'), Timestamp('2018-04-19 07:35:23')], [8, Timestamp('2018-04-19 07:39:41'), Timestamp('2018-04-19 07:41:10')], [8, Timestamp('2018-04-19 07:44:13'), Timestamp('2018-04-19 07:53:14')], [8, Timestamp('2018-04-19 07:58:13'), Timestamp('2018-04-19 08:20:23')], [1, Timestamp('2018-04-19 08:26:22'), Timestamp('2018-04-19 08:34:29')], [1, Timestamp('2018-04-19 08:42:02'), Timestamp('2018-04-19 09:05:43')], [1, Timestamp('2018-04-19 09:08:46'), Timestamp('2018-04-19 09:46:29')], [1, Timestamp('2018-04-19 09:50:44'), Timestamp('2018-04-19 09:54:58')], [26, Timestamp('2018-04-19 12:19:00'), Timestamp('2018-04-19 12:19:26')], [26, Timestamp('2018-04-19 12:24:07'), Timestamp('2018-04-19 12:25:53')], [27, Timestamp('2018-04-19 12:52:34'), Timestamp('2018-04-19 12:52:34')], [27, Timestamp('2018-04-19 12:57:43'), Timestamp('2018-04-19 13:00:14')], [10, Timestamp('2018-04-19 13:30:59'), Timestamp('2018-04-19 13:51:45')], [10, Timestamp('2018-04-19 13:58:55'), Timestamp('2018-04-19 14:21:02')], [10, Timestamp('2018-04-19 14:24:20'), Timestamp('2018-04-19 14:27:04')], [10, Timestamp('2018-04-19 14:32:00'), Timestamp('2018-04-19 14:52:40')], [10, Timestamp('2018-04-19 14:55:50'), Timestamp('2018-04-19 15:25:04')], [12, Timestamp('2018-04-19 15:47:50'), Timestamp('2018-04-19 15:50:33')], [12, Timestamp('2018-04-19 15:59:51'), Timestamp('2018-04-19 16:30:55')], [12, Timestamp('2018-04-19 16:34:53'), Timestamp('2018-04-19 16:40:43')], [12, Timestamp('2018-04-19 16:47:16'), Timestamp('2018-04-19 16:47:16')], [12, Timestamp('2018-04-19 16:58:21'), Timestamp('2018-04-19 17:16:02')], [12, Timestamp('2018-04-19 17:20:27'), Timestamp('2018-04-19 17:20:54')], [12, Timestamp('2018-04-19 17:27:21'), Timestamp('2018-04-19 17:34:53')], [12, Timestamp('2018-04-19 17:38:10'), Timestamp('2018-04-19 18:16:48')], [12, Timestamp('2018-04-19 18:20:21'), Timestamp('2018-04-19 18:28:19')], [4, Timestamp('2018-04-19 19:37:56'), Timestamp('2018-04-19 20:00:39')], [4, Timestamp('2018-04-19 20:03:58'), Timestamp('2018-04-19 20:22:24')], [4, Timestamp('2018-04-19 20:30:07'), Timestamp('2018-04-19 20:30:07')], [4, Timestamp('2018-04-19 20:38:07'), Timestamp('2018-04-19 20:50:11')], [4, Timestamp('2018-04-19 20:55:24'), Timestamp('2018-04-19 21:28:02')], [4, Timestamp('2018-04-19 21:31:48'), Timestamp('2018-04-19 22:07:53')], [5, Timestamp('2018-04-19 22:19:43'), Timestamp('2018-04-19 23:27:37')], [5, Timestamp('2018-04-19 23:30:53'), Timestamp('2018-04-19 23:59:11')], [5, Timestamp('2018-04-20 00:02:20'), Timestamp('2018-04-20 00:24:11')], [5, Timestamp('2018-04-20 00:27:20'), Timestamp('2018-04-20 00:28:05')], [5, Timestamp('2018-04-20 00:31:42'), Timestamp('2018-04-20 00:37:51')], [4, Timestamp('2018-04-20 00:45:17'), Timestamp('2018-04-20 01:03:15')], [4, Timestamp('2018-04-20 01:07:30'), Timestamp('2018-04-20 01:19:11')], [4, Timestamp('2018-04-20 01:22:52'), Timestamp('2018-04-20 01:28:51')], [4, Timestamp('2018-04-20 01:32:35'), Timestamp('2018-04-20 01:51:05')], [4, Timestamp('2018-04-20 01:55:11'), Timestamp('2018-04-20 02:33:32')], [4, Timestamp('2018-04-20 02:39:50'), Timestamp('2018-04-20 02:50:00')], [4, Timestamp('2018-04-20 02:53:08'), Timestamp('2018-04-20 03:20:57')], [5, Timestamp('2018-04-20 03:35:01'), Timestamp('2018-04-20 03:36:11')], [5, Timestamp('2018-04-20 03:39:41'), Timestamp('2018-04-20 03:50:44')], [5, Timestamp('2018-04-20 03:54:17'), Timestamp('2018-04-20 04:03:31')], [5, Timestamp('2018-04-20 04:08:34'), Timestamp('2018-04-20 04:36:02')], [5, Timestamp('2018-04-20 04:40:08'), Timestamp('2018-04-20 05:35:49')], [5, Timestamp('2018-04-20 05:41:12'), Timestamp('2018-04-20 06:03:38')], [5, Timestamp('2018-04-20 06:07:52'), Timestamp('2018-04-20 06:07:52')], [2, Timestamp('2018-04-20 06:13:12'), Timestamp('2018-04-20 06:52:47')], [2, Timestamp('2018-04-20 06:59:09'), Timestamp('2018-04-20 07:21:48')], [2, Timestamp('2018-04-20 07:25:15'), Timestamp('2018-04-20 07:33:28')], [2, Timestamp('2018-04-20 07:37:36'), Timestamp('2018-04-20 07:43:22')], [2, Timestamp('2018-04-20 07:46:37'), Timestamp('2018-04-20 07:52:30')], [2, Timestamp('2018-04-20 07:57:49'), Timestamp('2018-04-20 08:02:27')], [3, Timestamp('2018-04-20 08:09:23'), Timestamp('2018-04-20 08:12:07')], [3, Timestamp('2018-04-20 08:18:49'), Timestamp('2018-04-20 08:33:30')], [3, Timestamp('2018-04-20 11:49:29'), Timestamp('2018-04-20 11:51:02')], [3, Timestamp('2018-04-20 12:03:04'), Timestamp('2018-04-20 13:02:31')], [3, Timestamp('2018-04-20 13:07:07'), Timestamp('2018-04-20 13:27:33')], [3, Timestamp('2018-04-20 13:30:43'), Timestamp('2018-04-20 13:31:08')], [13, Timestamp('2018-04-20 13:37:14'), Timestamp('2018-04-20 14:07:32')], [13, Timestamp('2018-04-20 14:13:49'), Timestamp('2018-04-20 14:13:49')], [13, Timestamp('2018-04-20 14:18:09'), Timestamp('2018-04-20 14:32:40')], [13, Timestamp('2018-04-20 14:35:47'), Timestamp('2018-04-20 14:56:28')], [14, Timestamp('2018-04-20 15:00:40'), Timestamp('2018-04-20 15:01:42')], [14, Timestamp('2018-04-20 15:06:04'), Timestamp('2018-04-20 15:59:00')], [14, Timestamp('2018-04-20 16:04:39'), Timestamp('2018-04-20 16:09:55')], [10, Timestamp('2018-04-20 16:22:27'), Timestamp('2018-04-20 16:34:15')], [10, Timestamp('2018-04-20 16:48:43'), Timestamp('2018-04-20 17:12:11')], [10, Timestamp('2018-04-20 17:22:50'), Timestamp('2018-04-20 17:34:31')], [10, Timestamp('2018-04-20 17:38:51'), Timestamp('2018-04-20 17:51:18')], [12, Timestamp('2018-04-20 18:06:54'), Timestamp('2018-04-20 18:18:31')], [12, Timestamp('2018-04-20 18:25:00'), Timestamp('2018-04-20 18:43:47')], [12, Timestamp('2018-04-20 19:07:30'), Timestamp('2018-04-20 19:36:23')], [12, Timestamp('2018-04-20 19:53:36'), Timestamp('2018-04-20 20:25:21')], [12, Timestamp('2018-04-20 20:30:22'), Timestamp('2018-04-20 20:30:22')], [4, Timestamp('2018-04-20 21:01:25'), Timestamp('2018-04-20 21:06:57')], [4, Timestamp('2018-04-20 21:14:33'), Timestamp('2018-04-20 21:56:20')], [4, Timestamp('2018-04-20 21:59:52'), Timestamp('2018-04-20 22:07:21')], [4, Timestamp('2018-04-20 22:13:04'), Timestamp('2018-04-20 22:28:13')], [4, Timestamp('2018-04-20 22:33:56'), Timestamp('2018-04-20 22:33:56')], [4, Timestamp('2018-04-20 22:38:30'), Timestamp('2018-04-20 22:42:54')], [4, Timestamp('2018-04-20 22:47:09'), Timestamp('2018-04-20 23:25:27')], [5, Timestamp('2018-04-20 23:27:18'), Timestamp('2018-04-20 23:34:13')], [5, Timestamp('2018-04-20 23:37:44'), Timestamp('2018-04-21 00:05:36')], [5, Timestamp('2018-04-21 00:09:06'), Timestamp('2018-04-21 00:25:07')], [5, Timestamp('2018-04-21 00:29:15'), Timestamp('2018-04-21 00:53:41')], [5, Timestamp('2018-04-21 01:03:03'), Timestamp('2018-04-21 01:08:27')], [5, Timestamp('2018-04-21 01:13:46'), Timestamp('2018-04-21 01:23:53')], [5, Timestamp('2018-04-21 01:27:29'), Timestamp('2018-04-21 01:49:37')], [4, Timestamp('2018-04-21 01:54:27'), Timestamp('2018-04-21 01:58:11')], [4, Timestamp('2018-04-21 02:02:14'), Timestamp('2018-04-21 02:02:14')], [4, Timestamp('2018-04-21 02:06:28'), Timestamp('2018-04-21 04:02:34')], [4, Timestamp('2018-04-21 04:05:42'), Timestamp('2018-04-21 04:06:54')], [4, Timestamp('2018-04-21 04:13:48'), Timestamp('2018-04-21 04:24:28')], [5, Timestamp('2018-04-21 04:32:49'), Timestamp('2018-04-21 04:33:30')], [5, Timestamp('2018-04-21 04:42:54'), Timestamp('2018-04-21 04:51:02')], [5, Timestamp('2018-04-21 04:56:46'), Timestamp('2018-04-21 05:02:32')], [5, Timestamp('2018-04-21 05:05:51'), Timestamp('2018-04-21 05:05:51')], [5, Timestamp('2018-04-21 05:09:11'), Timestamp('2018-04-21 05:29:38')], [5, Timestamp('2018-04-21 05:32:40'), Timestamp('2018-04-21 05:44:48')], [5, Timestamp('2018-04-21 05:48:24'), Timestamp('2018-04-21 06:11:53')], [5, Timestamp('2018-04-21 06:16:21'), Timestamp('2018-04-21 07:06:02')], [24, Timestamp('2018-04-21 07:31:18'), Timestamp('2018-04-21 08:11:49')], [24, Timestamp('2018-04-21 08:15:38'), Timestamp('2018-04-21 08:55:31')], [24, Timestamp('2018-04-21 09:12:12'), Timestamp('2018-04-21 09:15:30')], [25, Timestamp('2018-04-21 09:28:30'), Timestamp('2018-04-21 09:56:11')], [25, Timestamp('2018-04-21 10:00:51'), Timestamp('2018-04-21 10:01:35')], [25, Timestamp('2018-04-21 10:04:42'), Timestamp('2018-04-21 10:55:15')], [25, Timestamp('2018-04-21 10:59:19'), Timestamp('2018-04-21 11:05:35')], [10, Timestamp('2018-04-21 11:29:40'), Timestamp('2018-04-21 11:50:57')], [10, Timestamp('2018-04-21 11:55:32'), Timestamp('2018-04-21 12:16:49')], [10, Timestamp('2018-04-21 12:20:16'), Timestamp('2018-04-21 12:36:26')], [10, Timestamp('2018-04-21 12:39:46'), Timestamp('2018-04-21 12:48:56')], [10, Timestamp('2018-04-21 12:52:29'), Timestamp('2018-04-21 13:15:12')], [10, Timestamp('2018-04-21 13:23:33'), Timestamp('2018-04-21 13:51:10')], [12, Timestamp('2018-04-21 14:00:50'), Timestamp('2018-04-21 14:10:08')], [12, Timestamp('2018-04-21 14:14:19'), Timestamp('2018-04-21 14:50:01')], [12, Timestamp('2018-04-21 14:57:26'), Timestamp('2018-04-21 14:59:15')], [12, Timestamp('2018-04-21 15:03:10'), Timestamp('2018-04-21 15:04:16')], [12, Timestamp('2018-04-21 15:07:17'), Timestamp('2018-04-21 15:13:28')], [12, Timestamp('2018-04-21 15:18:28'), Timestamp('2018-04-21 15:18:28')], [12, Timestamp('2018-04-21 15:24:08'), Timestamp('2018-04-21 15:45:30')], [12, Timestamp('2018-04-21 15:53:04'), Timestamp('2018-04-21 16:00:39')], [12, Timestamp('2018-04-21 16:05:02'), Timestamp('2018-04-21 16:07:20')], [12, Timestamp('2018-04-21 16:10:50'), Timestamp('2018-04-21 16:21:59')], [12, Timestamp('2018-04-21 16:25:14'), Timestamp('2018-04-21 16:53:25')], [12, Timestamp('2018-04-21 16:57:37'), Timestamp('2018-04-21 17:10:22')], [12, Timestamp('2018-04-21 17:13:30'), Timestamp('2018-04-21 17:19:33')], [12, Timestamp('2018-04-21 17:23:48'), Timestamp('2018-04-21 17:24:21')], [12, Timestamp('2018-04-21 17:31:11'), Timestamp('2018-04-21 17:33:15')], [12, Timestamp('2018-04-21 17:40:26'), Timestamp('2018-04-21 17:51:27')], [12, Timestamp('2018-04-21 17:54:56'), Timestamp('2018-04-21 18:12:49')], [4, Timestamp('2018-04-21 18:21:17'), Timestamp('2018-04-21 18:31:35')], [4, Timestamp('2018-04-21 18:35:58'), Timestamp('2018-04-21 18:56:05')], [4, Timestamp('2018-04-21 19:00:33'), Timestamp('2018-04-21 19:06:55')], [4, Timestamp('2018-04-21 19:14:24'), Timestamp('2018-04-21 19:19:22')], [4, Timestamp('2018-04-21 19:23:36'), Timestamp('2018-04-21 19:45:57')], [4, Timestamp('2018-04-21 19:49:37'), Timestamp('2018-04-21 19:57:26')], [4, Timestamp('2018-04-21 20:06:33'), Timestamp('2018-04-21 20:18:59')], [5, Timestamp('2018-04-21 20:23:08'), Timestamp('2018-04-21 20:59:11')], [5, Timestamp('2018-04-21 21:02:37'), Timestamp('2018-04-21 21:08:47')], [5, Timestamp('2018-04-21 21:13:07'), Timestamp('2018-04-21 21:28:55')], [5, Timestamp('2018-04-21 21:32:35'), Timestamp('2018-04-21 22:09:32')], [4, Timestamp('2018-04-21 22:24:17'), Timestamp('2018-04-21 23:05:28')], [4, Timestamp('2018-04-21 23:20:48'), Timestamp('2018-04-21 23:28:02')], [4, Timestamp('2018-04-21 23:33:09'), Timestamp('2018-04-21 23:53:16')], [4, Timestamp('2018-04-21 23:58:27'), Timestamp('2018-04-22 00:33:51')], [4, Timestamp('2018-04-22 00:38:46'), Timestamp('2018-04-22 00:43:05')], [4, Timestamp('2018-04-22 00:47:00'), Timestamp('2018-04-22 01:00:42')], [4, Timestamp('2018-04-22 01:06:29'), Timestamp('2018-04-22 01:12:56')], [5, Timestamp('2018-04-22 01:14:48'), Timestamp('2018-04-22 01:22:22')], [5, Timestamp('2018-04-22 01:25:31'), Timestamp('2018-04-22 02:19:47')], [5, Timestamp('2018-04-22 02:25:18'), Timestamp('2018-04-22 02:33:04')], [5, Timestamp('2018-04-22 02:37:54'), Timestamp('2018-04-22 02:49:46')], [5, Timestamp('2018-04-22 02:54:07'), Timestamp('2018-04-22 03:29:17')], [5, Timestamp('2018-04-22 03:32:18'), Timestamp('2018-04-22 03:32:18')], [5, Timestamp('2018-04-22 03:36:19'), Timestamp('2018-04-22 03:50:31')], [2, Timestamp('2018-04-22 03:54:33'), Timestamp('2018-04-22 04:10:41')], [2, Timestamp('2018-04-22 04:19:49'), Timestamp('2018-04-22 04:44:59')], [2, Timestamp('2018-04-22 04:50:50'), Timestamp('2018-04-22 04:58:48')], [2, Timestamp('2018-04-22 05:01:57'), Timestamp('2018-04-22 05:15:27')], [2, Timestamp('2018-04-22 05:19:43'), Timestamp('2018-04-22 05:41:59')], [3, Timestamp('2018-04-22 05:47:07'), Timestamp('2018-04-22 06:12:11')], [3, Timestamp('2018-04-22 06:16:18'), Timestamp('2018-04-22 07:17:41')], [3, Timestamp('2018-04-22 07:20:55'), Timestamp('2018-04-22 07:22:23')], [4, Timestamp('2018-04-22 07:28:11'), Timestamp('2018-04-22 07:43:40')], [4, Timestamp('2018-04-22 07:46:51'), Timestamp('2018-04-22 08:32:22')], [4, Timestamp('2018-04-22 08:37:10'), Timestamp('2018-04-22 08:38:08')], [4, Timestamp('2018-04-22 08:53:00'), Timestamp('2018-04-22 09:03:26')], [4, Timestamp('2018-04-22 09:08:04'), Timestamp('2018-04-22 09:23:46')], [4, Timestamp('2018-04-22 09:27:12'), Timestamp('2018-04-22 09:27:49')], [4, Timestamp('2018-04-22 09:32:17'), Timestamp('2018-04-22 09:52:15')], [4, Timestamp('2018-04-22 09:55:57'), Timestamp('2018-04-22 10:31:02')], [4, Timestamp('2018-04-22 10:34:58'), Timestamp('2018-04-22 10:44:25')], [4, Timestamp('2018-04-22 10:47:32'), Timestamp('2018-04-22 10:55:27')], [5, Timestamp('2018-04-22 10:57:19'), Timestamp('2018-04-22 11:23:03')], [5, Timestamp('2018-04-22 11:26:55'), Timestamp('2018-04-22 11:41:52')], [5, Timestamp('2018-04-22 11:46:59'), Timestamp('2018-04-22 11:52:02')], [5, Timestamp('2018-04-22 11:57:37'), Timestamp('2018-04-22 13:23:46')], [5, Timestamp('2018-04-22 13:27:22'), Timestamp('2018-04-22 14:14:40')], [5, Timestamp('2018-04-22 14:18:02'), Timestamp('2018-04-22 14:23:35')], [5, Timestamp('2018-04-22 14:27:11'), Timestamp('2018-04-22 14:32:20')], [9, Timestamp('2018-04-22 14:36:45'), Timestamp('2018-04-22 15:19:36')], [9, Timestamp('2018-04-22 15:23:43'), Timestamp('2018-04-22 15:23:43')], [9, Timestamp('2018-04-22 15:26:46'), Timestamp('2018-04-22 15:37:22')], [9, Timestamp('2018-04-22 15:42:42'), Timestamp('2018-04-22 15:44:12')], [13, Timestamp('2018-04-22 15:50:47'), Timestamp('2018-04-22 16:37:49')], [13, Timestamp('2018-04-22 16:42:41'), Timestamp('2018-04-22 16:49:08')], [13, Timestamp('2018-04-22 16:52:34'), Timestamp('2018-04-22 16:55:56')], [11, Timestamp('2018-04-22 17:00:16'), Timestamp('2018-04-22 17:26:55')], [11, Timestamp('2018-04-22 17:31:23'), Timestamp('2018-04-22 18:03:44')], [14, Timestamp('2018-04-22 18:37:25'), Timestamp('2018-04-22 18:39:54')], [14, Timestamp('2018-04-22 18:44:54'), Timestamp('2018-04-22 18:47:20')], [14, Timestamp('2018-04-22 18:51:20'), Timestamp('2018-04-22 18:54:12')], [14, Timestamp('2018-04-22 18:58:42'), Timestamp('2018-04-22 19:02:40')], [14, Timestamp('2018-04-22 19:06:22'), Timestamp('2018-04-22 19:42:38')], [14, Timestamp('2018-04-22 19:45:40'), Timestamp('2018-04-22 19:51:08')], [24, Timestamp('2018-04-22 20:09:15'), Timestamp('2018-04-22 20:09:15')], [24, Timestamp('2018-04-22 20:21:08'), Timestamp('2018-04-22 20:23:44')], [24, Timestamp('2018-04-22 20:27:40'), Timestamp('2018-04-22 20:43:23')], [24, Timestamp('2018-04-22 20:48:03'), Timestamp('2018-04-22 21:09:01')], [24, Timestamp('2018-04-22 21:17:10'), Timestamp('2018-04-22 22:04:20')], [24, Timestamp('2018-04-22 22:08:00'), Timestamp('2018-04-22 22:20:36')], [24, Timestamp('2018-04-22 22:24:18'), Timestamp('2018-04-22 22:31:04')], [24, Timestamp('2018-04-22 22:39:10'), Timestamp('2018-04-22 23:03:09')], [24, Timestamp('2018-04-22 23:11:04'), Timestamp('2018-04-22 23:41:36')], [24, Timestamp('2018-04-22 23:47:07'), Timestamp('2018-04-22 23:49:31')], [25, Timestamp('2018-04-22 23:59:33'), Timestamp('2018-04-23 00:06:01')], [25, Timestamp('2018-04-23 00:11:42'), Timestamp('2018-04-23 01:07:49')], [25, Timestamp('2018-04-23 01:11:10'), Timestamp('2018-04-23 01:26:53')], [25, Timestamp('2018-04-23 01:31:29'), Timestamp('2018-04-23 01:34:27')], [25, Timestamp('2018-04-23 01:42:27'), Timestamp('2018-04-23 01:51:36')], [25, Timestamp('2018-04-23 01:55:54'), Timestamp('2018-04-23 03:18:43')], [25, Timestamp('2018-04-23 03:27:38'), Timestamp('2018-04-23 03:27:38')], [25, Timestamp('2018-04-23 03:33:06'), Timestamp('2018-04-23 03:46:24')], [4, Timestamp('2018-04-23 03:52:39'), Timestamp('2018-04-23 04:08:11')], [4, Timestamp('2018-04-23 04:14:25'), Timestamp('2018-04-23 04:20:06')], [4, Timestamp('2018-04-23 04:28:40'), Timestamp('2018-04-23 04:35:09')], [4, Timestamp('2018-04-23 04:38:20'), Timestamp('2018-04-23 04:46:03')], [4, Timestamp('2018-04-23 04:49:43'), Timestamp('2018-04-23 05:33:42')], [4, Timestamp('2018-04-23 05:38:32'), Timestamp('2018-04-23 05:53:37')], [4, Timestamp('2018-04-23 05:56:41'), Timestamp('2018-04-23 05:57:18')], [4, Timestamp('2018-04-23 06:01:06'), Timestamp('2018-04-23 06:02:51')], [4, Timestamp('2018-04-23 06:10:17'), Timestamp('2018-04-23 06:16:49')], [4, Timestamp('2018-04-23 06:21:43'), Timestamp('2018-04-23 06:22:46')], [4, Timestamp('2018-04-23 06:26:19'), Timestamp('2018-04-23 06:47:42')], [5, Timestamp('2018-04-23 07:00:15'), Timestamp('2018-04-23 07:00:54')], [5, Timestamp('2018-04-23 07:04:51'), Timestamp('2018-04-23 07:24:16')], [5, Timestamp('2018-04-23 07:28:22'), Timestamp('2018-04-23 07:29:28')], [5, Timestamp('2018-04-23 07:32:36'), Timestamp('2018-04-23 07:58:42')], [5, Timestamp('2018-04-23 08:01:47'), Timestamp('2018-04-23 08:13:37')], [5, Timestamp('2018-04-23 08:17:00'), Timestamp('2018-04-23 08:31:24')], [5, Timestamp('2018-04-23 08:44:37'), Timestamp('2018-04-23 08:54:52')], [5, Timestamp('2018-04-23 08:58:18'), Timestamp('2018-04-23 09:03:57')], [5, Timestamp('2018-04-23 09:08:28'), Timestamp('2018-04-23 09:23:45')], [5, Timestamp('2018-04-23 09:28:44'), Timestamp('2018-04-23 09:32:29')], [5, Timestamp('2018-04-23 09:36:03'), Timestamp('2018-04-23 10:10:24')], [6, Timestamp('2018-04-23 10:27:35'), Timestamp('2018-04-23 10:27:35')], [6, Timestamp('2018-04-23 10:37:27'), Timestamp('2018-04-23 11:15:52')], [6, Timestamp('2018-04-23 11:27:44'), Timestamp('2018-04-23 11:30:20')], [6, Timestamp('2018-04-23 11:33:51'), Timestamp('2018-04-23 11:34:41')], [6, Timestamp('2018-04-23 11:39:15'), Timestamp('2018-04-23 11:52:08')], [6, Timestamp('2018-04-23 11:55:57'), Timestamp('2018-04-23 12:03:12')], [6, Timestamp('2018-04-23 12:06:34'), Timestamp('2018-04-23 12:06:59')], [6, Timestamp('2018-04-23 12:10:39'), Timestamp('2018-04-23 12:14:03')], [6, Timestamp('2018-04-23 12:21:28'), Timestamp('2018-04-23 12:21:28')], [28, Timestamp('2018-04-23 13:52:40'), Timestamp('2018-04-23 14:00:14')], [28, Timestamp('2018-04-23 14:09:51'), Timestamp('2018-04-23 14:09:52')], [29, Timestamp('2018-04-23 15:57:57'), Timestamp('2018-04-23 15:59:18')], [29, Timestamp('2018-04-23 16:02:41'), Timestamp('2018-04-23 16:07:58')], [6, Timestamp('2018-04-23 16:23:40'), Timestamp('2018-04-23 16:25:08')], [6, Timestamp('2018-04-23 16:32:34'), Timestamp('2018-04-23 16:39:22')], [6, Timestamp('2018-04-23 16:42:43'), Timestamp('2018-04-23 16:48:27')], [6, Timestamp('2018-04-23 16:53:25'), Timestamp('2018-04-23 16:58:14')], [7, Timestamp('2018-04-23 17:01:37'), Timestamp('2018-04-23 17:08:11')], [7, Timestamp('2018-04-23 17:11:47'), Timestamp('2018-04-23 17:21:25')], [7, Timestamp('2018-04-23 17:27:58'), Timestamp('2018-04-23 17:35:17')], [7, Timestamp('2018-04-23 17:43:17'), Timestamp('2018-04-23 17:55:35')], [7, Timestamp('2018-04-23 18:00:33'), Timestamp('2018-04-23 18:16:11')], [7, Timestamp('2018-04-23 18:21:19'), Timestamp('2018-04-23 18:22:48')], [7, Timestamp('2018-04-23 18:27:04'), Timestamp('2018-04-23 18:54:02')], [10, Timestamp('2018-04-23 19:14:05'), Timestamp('2018-04-23 19:30:53')], [10, Timestamp('2018-04-23 19:34:12'), Timestamp('2018-04-23 20:17:42')], [10, Timestamp('2018-04-23 20:21:23'), Timestamp('2018-04-23 20:47:16')], [12, Timestamp('2018-04-23 21:05:49'), Timestamp('2018-04-23 21:14:30')], [12, Timestamp('2018-04-23 21:20:41'), Timestamp('2018-04-23 21:26:26')], [12, Timestamp('2018-04-23 21:29:50'), Timestamp('2018-04-23 21:36:56')], [12, Timestamp('2018-04-23 21:41:55'), Timestamp('2018-04-23 21:47:15')], [12, Timestamp('2018-04-23 21:54:03'), Timestamp('2018-04-23 21:54:03')], [12, Timestamp('2018-04-23 22:03:58'), Timestamp('2018-04-23 22:18:09')], [12, Timestamp('2018-04-23 22:21:11'), Timestamp('2018-04-23 22:40:05')], [12, Timestamp('2018-04-23 22:47:57'), Timestamp('2018-04-23 22:58:20')], [12, Timestamp('2018-04-23 23:05:19'), Timestamp('2018-04-23 23:12:01')], [12, Timestamp('2018-04-23 23:15:20'), Timestamp('2018-04-23 23:30:39')], [12, Timestamp('2018-04-23 23:33:42'), Timestamp('2018-04-23 23:36:22')], [12, Timestamp('2018-04-23 23:39:57'), Timestamp('2018-04-23 23:45:35')], [12, Timestamp('2018-04-23 23:55:24'), Timestamp('2018-04-24 00:10:39')], [10, Timestamp('2018-04-24 00:13:17'), Timestamp('2018-04-24 00:48:59')], [10, Timestamp('2018-04-24 00:52:24'), Timestamp('2018-04-24 02:00:50')], [12, Timestamp('2018-04-24 02:08:21'), Timestamp('2018-04-24 02:38:09')], [12, Timestamp('2018-04-24 02:42:09'), Timestamp('2018-04-24 03:10:27')], [12, Timestamp('2018-04-24 03:19:50'), Timestamp('2018-04-24 03:29:09')], [12, Timestamp('2018-04-24 03:32:56'), Timestamp('2018-04-24 03:32:56')], [12, Timestamp('2018-04-24 03:37:00'), Timestamp('2018-04-24 03:53:10')], [12, Timestamp('2018-04-24 03:59:23'), Timestamp('2018-04-24 04:02:03')], [12, Timestamp('2018-04-24 04:07:36'), Timestamp('2018-04-24 04:11:20')], [12, Timestamp('2018-04-24 04:16:03'), Timestamp('2018-04-24 04:23:13')], [12, Timestamp('2018-04-24 04:29:12'), Timestamp('2018-04-24 04:34:44')], [12, Timestamp('2018-04-24 04:42:28'), Timestamp('2018-04-24 04:54:03')], [12, Timestamp('2018-04-24 04:57:08'), Timestamp('2018-04-24 05:08:30')], [20, Timestamp('2018-04-24 06:23:52'), Timestamp('2018-04-24 06:45:59')], [20, Timestamp('2018-04-24 06:49:31'), Timestamp('2018-04-24 07:18:13')], [20, Timestamp('2018-04-24 07:22:53'), Timestamp('2018-04-24 07:40:16')], [20, Timestamp('2018-04-24 07:43:38'), Timestamp('2018-04-24 07:48:49')], [20, Timestamp('2018-04-24 07:52:45'), Timestamp('2018-04-24 08:00:09')], [20, Timestamp('2018-04-24 08:03:29'), Timestamp('2018-04-24 08:23:46')], [20, Timestamp('2018-04-24 08:29:30'), Timestamp('2018-04-24 08:36:47')], [20, Timestamp('2018-04-24 08:41:03'), Timestamp('2018-04-24 09:45:39')], [20, Timestamp('2018-04-24 09:53:15'), Timestamp('2018-04-24 09:55:11')], [20, Timestamp('2018-04-24 09:58:41'), Timestamp('2018-04-24 09:58:41')], [20, Timestamp('2018-04-24 10:03:01'), Timestamp('2018-04-24 10:03:01')], [20, Timestamp('2018-04-24 10:06:25'), Timestamp('2018-04-24 10:07:09')], [20, Timestamp('2018-04-24 10:10:23'), Timestamp('2018-04-24 10:12:28')], [20, Timestamp('2018-04-24 10:16:37'), Timestamp('2018-04-24 10:50:04')], [20, Timestamp('2018-04-24 10:56:19'), Timestamp('2018-04-24 11:01:45')], [20, Timestamp('2018-04-24 11:06:23'), Timestamp('2018-04-24 11:25:27')], [20, Timestamp('2018-04-24 11:34:46'), Timestamp('2018-04-24 11:49:44')], [20, Timestamp('2018-04-24 11:59:24'), Timestamp('2018-04-24 12:10:23')], [20, Timestamp('2018-04-24 12:13:29'), Timestamp('2018-04-24 12:21:17')], [20, Timestamp('2018-04-24 12:26:44'), Timestamp('2018-04-24 12:49:56')], [20, Timestamp('2018-04-24 13:02:01'), Timestamp('2018-04-24 13:05:54')], [20, Timestamp('2018-04-24 13:09:08'), Timestamp('2018-04-24 13:19:07')], [20, Timestamp('2018-04-24 13:29:09'), Timestamp('2018-04-24 13:36:43')], [20, Timestamp('2018-04-24 13:41:08'), Timestamp('2018-04-24 13:57:46')], [8, Timestamp('2018-04-24 14:20:38'), Timestamp('2018-04-24 15:28:23')], [1, Timestamp('2018-04-24 16:27:51'), Timestamp('2018-04-24 16:27:51')], [1, Timestamp('2018-04-24 16:32:30'), Timestamp('2018-04-24 16:34:55')], [1, Timestamp('2018-04-24 16:39:51'), Timestamp('2018-04-24 16:45:14')], [1, Timestamp('2018-04-24 16:48:22'), Timestamp('2018-04-24 16:56:00')], [1, Timestamp('2018-04-24 17:02:06'), Timestamp('2018-04-24 17:07:27')], [1, Timestamp('2018-04-24 17:13:18'), Timestamp('2018-04-24 17:24:33')], [1, Timestamp('2018-04-24 17:27:50'), Timestamp('2018-04-24 17:34:41')], [22, Timestamp('2018-04-24 18:11:50'), Timestamp('2018-04-24 18:17:10')], [22, Timestamp('2018-04-24 18:25:27'), Timestamp('2018-04-24 18:25:27')], [22, Timestamp('2018-04-24 18:34:32'), Timestamp('2018-04-24 18:53:35')], [22, Timestamp('2018-04-24 18:58:26'), Timestamp('2018-04-24 19:13:02')], [22, Timestamp('2018-04-24 19:25:10'), Timestamp('2018-04-24 19:33:30')], [22, Timestamp('2018-04-24 19:48:28'), Timestamp('2018-04-24 20:26:33')], [22, Timestamp('2018-04-24 20:32:09'), Timestamp('2018-04-24 20:50:09')], [22, Timestamp('2018-04-24 20:54:30'), Timestamp('2018-04-24 21:11:25')], [23, Timestamp('2018-04-24 21:15:05'), Timestamp('2018-04-24 21:29:25')], [23, Timestamp('2018-04-24 21:33:07'), Timestamp('2018-04-24 21:33:07')], [23, Timestamp('2018-04-24 21:39:07'), Timestamp('2018-04-24 21:56:59')], [23, Timestamp('2018-04-24 22:00:09'), Timestamp('2018-04-24 22:07:12')], [23, Timestamp('2018-04-24 22:12:14'), Timestamp('2018-04-24 22:25:14')], [23, Timestamp('2018-04-24 22:29:10'), Timestamp('2018-04-24 23:13:22')], [23, Timestamp('2018-04-24 23:17:12'), Timestamp('2018-04-24 23:26:53')], [28, Timestamp('2018-04-24 23:53:45'), Timestamp('2018-04-24 23:58:54')], [28, Timestamp('2018-04-25 00:02:27'), Timestamp('2018-04-25 00:03:51')], [28, Timestamp('2018-04-25 00:09:01'), Timestamp('2018-04-25 00:13:21')], [28, Timestamp('2018-04-25 00:18:29'), Timestamp('2018-04-25 00:32:52')], [28, Timestamp('2018-04-25 00:37:29'), Timestamp('2018-04-25 00:51:44')], [28, Timestamp('2018-04-25 01:01:59'), Timestamp('2018-04-25 01:14:02')], [28, Timestamp('2018-04-25 01:20:36'), Timestamp('2018-04-25 01:24:21')], [28, Timestamp('2018-04-25 01:29:21'), Timestamp('2018-04-25 01:29:21')], [29, Timestamp('2018-04-25 01:39:38'), Timestamp('2018-04-25 03:12:45')], [29, Timestamp('2018-04-25 03:17:36'), Timestamp('2018-04-25 03:28:21')], [29, Timestamp('2018-04-25 03:32:08'), Timestamp('2018-04-25 03:56:41')], [29, Timestamp('2018-04-25 03:59:48'), Timestamp('2018-04-25 04:09:33')], [2, Timestamp('2018-04-25 04:22:13'), Timestamp('2018-04-25 04:27:40')], [2, Timestamp('2018-04-25 04:31:21'), Timestamp('2018-04-25 05:28:27')], [2, Timestamp('2018-04-25 05:44:51'), Timestamp('2018-04-25 06:05:09')], [2, Timestamp('2018-04-25 06:08:31'), Timestamp('2018-04-25 06:12:38')], [2, Timestamp('2018-04-25 06:20:34'), Timestamp('2018-04-25 06:25:37')], [3, Timestamp('2018-04-25 06:33:03'), Timestamp('2018-04-25 06:47:08')], [3, Timestamp('2018-04-25 06:50:27'), Timestamp('2018-04-25 07:35:20')], [3, Timestamp('2018-04-25 07:39:16'), Timestamp('2018-04-25 08:10:12')], [9, Timestamp('2018-04-25 08:16:58'), Timestamp('2018-04-25 08:17:48')], [9, Timestamp('2018-04-25 14:17:50'), Timestamp('2018-04-25 14:17:50')], [9, Timestamp('2018-04-25 14:38:17'), Timestamp('2018-04-25 15:07:45')], [4, Timestamp('2018-04-25 15:13:18'), Timestamp('2018-04-25 15:44:10')], [4, Timestamp('2018-04-25 15:48:28'), Timestamp('2018-04-25 15:53:52')], [4, Timestamp('2018-04-25 15:58:01'), Timestamp('2018-04-25 15:58:01')], [4, Timestamp('2018-04-25 16:03:04'), Timestamp('2018-04-25 16:03:04')], [4, Timestamp('2018-04-25 16:09:47'), Timestamp('2018-04-25 16:25:08')], [4, Timestamp('2018-04-25 16:28:18'), Timestamp('2018-04-25 16:54:44')], [4, Timestamp('2018-04-25 16:57:57'), Timestamp('2018-04-25 17:17:00')], [4, Timestamp('2018-04-25 17:22:14'), Timestamp('2018-04-25 17:28:06')], [5, Timestamp('2018-04-25 17:32:29'), Timestamp('2018-04-25 17:36:58')], [5, Timestamp('2018-04-25 17:41:32'), Timestamp('2018-04-25 18:37:13')], [5, Timestamp('2018-04-25 18:43:29'), Timestamp('2018-04-25 19:09:31')], [5, Timestamp('2018-04-25 19:13:08'), Timestamp('2018-04-25 19:24:40')], [5, Timestamp('2018-04-25 19:28:49'), Timestamp('2018-04-25 19:38:17')], [4, Timestamp('2018-04-25 19:45:40'), Timestamp('2018-04-25 19:54:32')], [4, Timestamp('2018-04-25 19:58:34'), Timestamp('2018-04-25 20:20:26')], [4, Timestamp('2018-04-25 20:23:30'), Timestamp('2018-04-25 20:27:41')], [4, Timestamp('2018-04-25 20:30:53'), Timestamp('2018-04-25 21:01:22')], [5, Timestamp('2018-04-25 21:04:32'), Timestamp('2018-04-25 21:39:45')], [5, Timestamp('2018-04-25 21:45:42'), Timestamp('2018-04-25 21:58:01')], [5, Timestamp('2018-04-25 22:05:04'), Timestamp('2018-04-25 22:40:04')], [8, Timestamp('2018-04-25 23:02:30'), Timestamp('2018-04-25 23:47:53')], [8, Timestamp('2018-04-25 23:51:29'), Timestamp('2018-04-26 00:40:41')], [8, Timestamp('2018-04-26 00:44:49'), Timestamp('2018-04-26 00:44:49')], [8, Timestamp('2018-04-26 00:52:11'), Timestamp('2018-04-26 00:52:11')], [8, Timestamp('2018-04-26 00:59:46'), Timestamp('2018-04-26 01:04:46')], [1, Timestamp('2018-04-26 01:12:16'), Timestamp('2018-04-26 01:36:31')], [1, Timestamp('2018-04-26 01:40:21'), Timestamp('2018-04-26 02:12:52')], [1, Timestamp('2018-04-26 02:19:35'), Timestamp('2018-04-26 02:43:43')], [16, Timestamp('2018-04-26 02:50:08'), Timestamp('2018-04-26 03:01:56')], [16, Timestamp('2018-04-26 03:11:59'), Timestamp('2018-04-26 03:17:00')], [16, Timestamp('2018-04-26 03:22:21'), Timestamp('2018-04-26 04:14:12')], [18, Timestamp('2018-04-26 04:17:12'), Timestamp('2018-04-26 04:31:50')], [18, Timestamp('2018-04-26 04:36:55'), Timestamp('2018-04-26 04:49:01')], [18, Timestamp('2018-04-26 04:53:48'), Timestamp('2018-04-26 04:55:58')], [18, Timestamp('2018-04-26 04:59:58'), Timestamp('2018-04-26 05:23:32')], [16, Timestamp('2018-04-26 05:29:03'), Timestamp('2018-04-26 05:35:25')], [16, Timestamp('2018-04-26 05:40:53'), Timestamp('2018-04-26 06:03:18')], [16, Timestamp('2018-04-26 06:06:22'), Timestamp('2018-04-26 06:47:41')], [18, Timestamp('2018-04-26 06:49:38'), Timestamp('2018-04-26 07:11:18')], [18, Timestamp('2018-04-26 07:23:02'), Timestamp('2018-04-26 07:23:02')], [18, Timestamp('2018-04-26 07:58:52'), Timestamp('2018-04-26 08:30:38')], [19, Timestamp('2018-04-26 09:07:32'), Timestamp('2018-04-26 09:14:54')], [19, Timestamp('2018-04-26 09:22:17'), Timestamp('2018-04-26 09:43:59')], [19, Timestamp('2018-04-26 09:47:07'), Timestamp('2018-04-26 10:14:40')], [21, Timestamp('2018-04-26 10:37:26'), Timestamp('2018-04-26 10:37:26')], [21, Timestamp('2018-04-26 10:42:50'), Timestamp('2018-04-26 10:46:13')], [21, Timestamp('2018-04-26 10:49:33'), Timestamp('2018-04-26 10:50:23')], [21, Timestamp('2018-04-26 10:55:43'), Timestamp('2018-04-26 11:01:18')], [21, Timestamp('2018-04-26 11:08:18'), Timestamp('2018-04-26 11:14:37')], [21, Timestamp('2018-04-26 11:17:43'), Timestamp('2018-04-26 11:18:23')], [21, Timestamp('2018-04-26 11:25:18'), Timestamp('2018-04-26 11:40:39')], [21, Timestamp('2018-04-26 11:46:32'), Timestamp('2018-04-26 11:52:01')], [21, Timestamp('2018-04-26 12:08:36'), Timestamp('2018-04-26 12:48:06')], [21, Timestamp('2018-04-26 12:55:12'), Timestamp('2018-04-26 12:55:12')], [15, Timestamp('2018-04-26 13:07:08'), Timestamp('2018-04-26 13:36:37')], [15, Timestamp('2018-04-26 13:43:26'), Timestamp('2018-04-26 14:06:16')], [15, Timestamp('2018-04-26 14:10:42'), Timestamp('2018-04-26 14:12:05')], [15, Timestamp('2018-04-26 14:17:52'), Timestamp('2018-04-26 14:19:37')], [17, Timestamp('2018-04-26 14:26:16'), Timestamp('2018-04-26 14:26:16')], [17, Timestamp('2018-04-26 14:34:33'), Timestamp('2018-04-26 14:40:38')], [17, Timestamp('2018-04-26 14:44:03'), Timestamp('2018-04-26 14:55:47')], [17, Timestamp('2018-04-26 15:02:16'), Timestamp('2018-04-26 15:11:54')], [17, Timestamp('2018-04-26 15:19:03'), Timestamp('2018-04-26 15:21:06')], [17, Timestamp('2018-04-26 15:26:09'), Timestamp('2018-04-26 15:33:04')], [17, Timestamp('2018-04-26 15:37:37'), Timestamp('2018-04-26 15:50:04')], [21, Timestamp('2018-04-26 15:56:50'), Timestamp('2018-04-26 15:57:39')], [9, Timestamp('2018-04-26 16:16:55'), Timestamp('2018-04-26 16:24:16')], [9, Timestamp('2018-04-26 16:34:59'), Timestamp('2018-04-26 17:57:00')], [11, Timestamp('2018-04-26 18:06:36'), Timestamp('2018-04-26 18:55:34')], [11, Timestamp('2018-04-26 19:02:42'), Timestamp('2018-04-26 19:12:21')], [11, Timestamp('2018-04-26 19:17:52'), Timestamp('2018-04-26 19:41:04')], [11, Timestamp('2018-04-26 19:51:15'), Timestamp('2018-04-26 20:27:38')], [4, Timestamp('2018-04-26 20:40:37'), Timestamp('2018-04-26 20:53:51')], [4, Timestamp('2018-04-26 20:58:38'), Timestamp('2018-04-26 21:04:10')], [4, Timestamp('2018-04-26 21:07:45'), Timestamp('2018-04-26 21:20:28')], [4, Timestamp('2018-04-26 21:28:55'), Timestamp('2018-04-26 22:18:39')], [4, Timestamp('2018-04-26 22:27:30'), Timestamp('2018-04-26 22:52:59')], [4, Timestamp('2018-04-26 22:56:14'), Timestamp('2018-04-26 23:04:51')], [4, Timestamp('2018-04-26 23:08:40'), Timestamp('2018-04-26 23:46:02')], [4, Timestamp('2018-04-26 23:52:01'), Timestamp('2018-04-26 23:57:46')], [5, Timestamp('2018-04-27 00:16:52'), Timestamp('2018-04-27 02:05:25')], [4, Timestamp('2018-04-27 02:11:48'), Timestamp('2018-04-27 02:31:26')], [4, Timestamp('2018-04-27 02:52:40'), Timestamp('2018-04-27 03:11:35')], [4, Timestamp('2018-04-27 03:19:56'), Timestamp('2018-04-27 03:20:29')], [4, Timestamp('2018-04-27 03:28:30'), Timestamp('2018-04-27 03:31:44')], [5, Timestamp('2018-04-27 03:35:22'), Timestamp('2018-04-27 03:37:14')], [5, Timestamp('2018-04-27 03:41:32'), Timestamp('2018-04-27 03:42:37')], [5, Timestamp('2018-04-27 03:49:27'), Timestamp('2018-04-27 03:51:17')], [5, Timestamp('2018-04-27 03:55:47'), Timestamp('2018-04-27 04:06:08')], [5, Timestamp('2018-04-27 04:10:01'), Timestamp('2018-04-27 04:16:59')], [5, Timestamp('2018-04-27 04:20:06'), Timestamp('2018-04-27 04:53:51')], [5, Timestamp('2018-04-27 04:57:27'), Timestamp('2018-04-27 05:03:46')], [5, Timestamp('2018-04-27 05:06:51'), Timestamp('2018-04-27 05:08:14')], [5, Timestamp('2018-04-27 05:14:46'), Timestamp('2018-04-27 05:24:20')], [5, Timestamp('2018-04-27 05:32:39'), Timestamp('2018-04-27 05:32:39')], [5, Timestamp('2018-04-27 05:39:37'), Timestamp('2018-04-27 05:46:09')], [5, Timestamp('2018-04-27 05:49:24'), Timestamp('2018-04-27 05:49:24')], [5, Timestamp('2018-04-27 05:53:19'), Timestamp('2018-04-27 05:57:59')], [5, Timestamp('2018-04-27 06:01:17'), Timestamp('2018-04-27 06:05:36')], [5, Timestamp('2018-04-27 06:09:32'), Timestamp('2018-04-27 06:12:02')], [5, Timestamp('2018-04-27 06:16:56'), Timestamp('2018-04-27 06:17:32')], [2, Timestamp('2018-04-27 06:24:56'), Timestamp('2018-04-27 06:45:01')], [8, Timestamp('2018-04-27 07:09:34'), Timestamp('2018-04-27 07:16:42')], [8, Timestamp('2018-04-27 07:19:43'), Timestamp('2018-04-27 07:39:08')], [8, Timestamp('2018-04-27 07:42:58'), Timestamp('2018-04-27 07:44:08')], [8, Timestamp('2018-04-27 07:47:24'), Timestamp('2018-04-27 07:51:09')], [8, Timestamp('2018-04-27 07:56:14'), Timestamp('2018-04-27 09:34:03')], [1, Timestamp('2018-04-27 09:35:53'), Timestamp('2018-04-27 09:35:53')], [1, Timestamp('2018-04-27 09:41:22'), Timestamp('2018-04-27 09:45:38')], [1, Timestamp('2018-04-27 09:49:46'), Timestamp('2018-04-27 09:52:39')], [1, Timestamp('2018-04-27 09:58:05'), Timestamp('2018-04-27 10:37:05')], [1, Timestamp('2018-04-27 10:40:52'), Timestamp('2018-04-27 11:39:23')], [1, Timestamp('2018-04-27 11:45:50'), Timestamp('2018-04-27 11:51:35')], [30, Timestamp('2018-04-27 12:35:00'), Timestamp('2018-04-27 13:03:00')], [30, Timestamp('2018-04-27 13:06:41'), Timestamp('2018-04-27 13:14:01')], [30, Timestamp('2018-04-27 13:38:29'), Timestamp('2018-04-27 13:42:47')], [31, Timestamp('2018-04-27 16:05:01'), Timestamp('2018-04-27 16:23:05')], [31, Timestamp('2018-04-27 16:29:26'), Timestamp('2018-04-27 16:34:39')], [31, Timestamp('2018-04-27 16:44:13'), Timestamp('2018-04-27 16:53:28')], [30, Timestamp('2018-04-27 17:03:37'), Timestamp('2018-04-27 17:09:33')], [30, Timestamp('2018-04-27 17:12:56'), Timestamp('2018-04-27 18:01:50')], [31, Timestamp('2018-04-27 18:07:48'), Timestamp('2018-04-27 18:08:58')], [31, Timestamp('2018-04-27 18:14:02'), Timestamp('2018-04-27 18:38:04')], [31, Timestamp('2018-04-27 18:43:02'), Timestamp('2018-04-27 18:50:41')], [31, Timestamp('2018-04-27 18:54:30'), Timestamp('2018-04-27 19:07:05')], [31, Timestamp('2018-04-27 19:11:14'), Timestamp('2018-04-27 19:18:07')], [32, Timestamp('2018-04-27 19:25:30'), Timestamp('2018-04-27 19:45:04')], [32, Timestamp('2018-04-27 19:59:57'), Timestamp('2018-04-27 20:04:29')], [32, Timestamp('2018-04-27 21:01:00'), Timestamp('2018-04-27 21:21:12')], [32, Timestamp('2018-04-27 21:26:01'), Timestamp('2018-04-27 21:26:01')], [32, Timestamp('2018-04-27 21:29:14'), Timestamp('2018-04-27 21:38:02')], [33, Timestamp('2018-04-27 21:47:07'), Timestamp('2018-04-27 21:47:07')], [33, Timestamp('2018-04-27 21:51:57'), Timestamp('2018-04-27 21:53:09')], [33, Timestamp('2018-04-27 21:57:56'), Timestamp('2018-04-27 22:05:44')], [33, Timestamp('2018-04-27 22:12:18'), Timestamp('2018-04-27 22:26:18')], [33, Timestamp('2018-04-27 22:30:25'), Timestamp('2018-04-27 22:56:28')], [4, Timestamp('2018-04-27 23:07:35'), Timestamp('2018-04-27 23:58:32')], [4, Timestamp('2018-04-28 00:04:51'), Timestamp('2018-04-28 01:06:48')], [4, Timestamp('2018-04-28 01:10:07'), Timestamp('2018-04-28 01:26:25')], [4, Timestamp('2018-04-28 01:30:15'), Timestamp('2018-04-28 01:46:57')], [5, Timestamp('2018-04-28 01:55:32'), Timestamp('2018-04-28 02:03:07')], [5, Timestamp('2018-04-28 02:06:09'), Timestamp('2018-04-28 02:38:31')], [5, Timestamp('2018-04-28 02:41:50'), Timestamp('2018-04-28 03:05:37')], [5, Timestamp('2018-04-28 03:09:36'), Timestamp('2018-04-28 03:18:33')], [5, Timestamp('2018-04-28 03:22:36'), Timestamp('2018-04-28 03:36:06')], [5, Timestamp('2018-04-28 03:41:08'), Timestamp('2018-04-28 03:42:07')], [5, Timestamp('2018-04-28 03:45:45'), Timestamp('2018-04-28 03:53:36')], [5, Timestamp('2018-04-28 03:56:51'), Timestamp('2018-04-28 04:16:38')], [5, Timestamp('2018-04-28 04:20:37'), Timestamp('2018-04-28 04:26:49')], [5, Timestamp('2018-04-28 04:30:57'), Timestamp('2018-04-28 04:48:54')], [2, Timestamp('2018-04-28 05:10:09'), Timestamp('2018-04-28 05:17:56')], [2, Timestamp('2018-04-28 05:20:59'), Timestamp('2018-04-28 05:23:32')], [2, Timestamp('2018-04-28 05:45:12'), Timestamp('2018-04-28 06:00:59')], [8, Timestamp('2018-04-28 06:22:14'), Timestamp('2018-04-28 06:26:15')], [8, Timestamp('2018-04-28 06:29:47'), Timestamp('2018-04-28 06:38:07')], [8, Timestamp('2018-04-28 06:49:24'), Timestamp('2018-04-28 08:10:21')], [8, Timestamp('2018-04-28 08:14:18'), Timestamp('2018-04-28 08:42:06')], [8, Timestamp('2018-04-28 08:46:37'), Timestamp('2018-04-28 08:48:21')], [8, Timestamp('2018-04-28 08:51:45'), Timestamp('2018-04-28 08:58:57')], [1, Timestamp('2018-04-28 09:05:01'), Timestamp('2018-04-28 09:05:52')], [1, Timestamp('2018-04-28 09:11:26'), Timestamp('2018-04-28 09:11:52')], [1, Timestamp('2018-04-28 09:15:45'), Timestamp('2018-04-28 09:28:09')], [1, Timestamp('2018-04-28 09:32:45'), Timestamp('2018-04-28 09:37:37')], [1, Timestamp('2018-04-28 09:40:50'), Timestamp('2018-04-28 09:47:05')], [1, Timestamp('2018-04-28 09:51:56'), Timestamp('2018-04-28 10:04:43')], [1, Timestamp('2018-04-28 10:09:56'), Timestamp('2018-04-28 10:17:18')], [1, Timestamp('2018-04-28 10:20:41'), Timestamp('2018-04-28 10:32:19')], [1, Timestamp('2018-04-28 10:35:54'), Timestamp('2018-04-28 10:55:48')], [1, Timestamp('2018-04-28 11:02:46'), Timestamp('2018-04-28 11:04:31')], [1, Timestamp('2018-04-28 11:07:38'), Timestamp('2018-04-28 11:14:34')], [1, Timestamp('2018-04-28 11:21:56'), Timestamp('2018-04-28 11:22:15')], [1, Timestamp('2018-04-28 11:27:56'), Timestamp('2018-04-28 11:28:37')], [1, Timestamp('2018-04-28 11:34:32'), Timestamp('2018-04-28 11:34:32')], [1, Timestamp('2018-04-28 11:42:42'), Timestamp('2018-04-28 11:42:42')], [1, Timestamp('2018-04-28 11:49:52'), Timestamp('2018-04-28 11:52:16')], [2, Timestamp('2018-04-28 12:24:54'), Timestamp('2018-04-28 12:48:13')], [2, Timestamp('2018-04-28 12:51:51'), Timestamp('2018-04-28 12:52:24')], [2, Timestamp('2018-04-28 12:56:02'), Timestamp('2018-04-28 13:39:37')], [2, Timestamp('2018-04-28 13:44:04'), Timestamp('2018-04-28 13:54:24')], [3, Timestamp('2018-04-28 14:01:44'), Timestamp('2018-04-28 14:10:43')], [3, Timestamp('2018-04-28 14:13:45'), Timestamp('2018-04-28 14:41:06')], [3, Timestamp('2018-04-28 14:45:53'), Timestamp('2018-04-28 14:59:51')], [3, Timestamp('2018-04-28 15:03:01'), Timestamp('2018-04-28 15:13:04')], [3, Timestamp('2018-04-28 15:17:45'), Timestamp('2018-04-28 15:25:19')], [3, Timestamp('2018-04-28 15:28:33'), Timestamp('2018-04-28 16:03:06')], [3, Timestamp('2018-04-28 16:09:00'), Timestamp('2018-04-28 16:30:04')], [9, Timestamp('2018-04-28 16:36:25'), Timestamp('2018-04-28 17:04:45')], [9, Timestamp('2018-04-28 17:07:57'), Timestamp('2018-04-28 17:36:43')], [9, Timestamp('2018-04-28 17:41:40'), Timestamp('2018-04-28 18:12:54')], [13, Timestamp('2018-04-28 18:20:45'), Timestamp('2018-04-28 18:20:45')], [13, Timestamp('2018-04-28 18:26:00'), Timestamp('2018-04-28 19:14:39')], [13, Timestamp('2018-04-28 19:20:40'), Timestamp('2018-04-28 19:29:38')], [13, Timestamp('2018-04-28 19:34:41'), Timestamp('2018-04-28 19:36:05')], [11, Timestamp('2018-04-28 19:50:57'), Timestamp('2018-04-28 19:51:20')], [11, Timestamp('2018-04-28 19:55:53'), Timestamp('2018-04-28 20:20:31')], [11, Timestamp('2018-04-28 20:24:58'), Timestamp('2018-04-28 20:43:15')], [11, Timestamp('2018-04-28 20:48:06'), Timestamp('2018-04-28 21:23:51')], [11, Timestamp('2018-04-28 21:28:44'), Timestamp('2018-04-28 21:30:34')], [14, Timestamp('2018-04-28 21:34:59'), Timestamp('2018-04-28 21:44:14')], [14, Timestamp('2018-04-28 21:50:00'), Timestamp('2018-04-28 22:04:52')], [14, Timestamp('2018-04-28 22:15:33'), Timestamp('2018-04-28 22:30:02')], [14, Timestamp('2018-04-28 22:33:31'), Timestamp('2018-04-28 22:43:44')], [10, Timestamp('2018-04-28 23:12:56'), Timestamp('2018-04-29 00:28:30')], [10, Timestamp('2018-04-29 00:35:24'), Timestamp('2018-04-29 00:40:46')], [10, Timestamp('2018-04-29 00:50:06'), Timestamp('2018-04-29 00:55:52')], [10, Timestamp('2018-04-29 01:00:55'), Timestamp('2018-04-29 01:37:56')], [12, Timestamp('2018-04-29 01:48:05'), Timestamp('2018-04-29 01:49:17')], [12, Timestamp('2018-04-29 01:54:50'), Timestamp('2018-04-29 01:54:50')], [12, Timestamp('2018-04-29 02:04:37'), Timestamp('2018-04-29 02:08:18')], [12, Timestamp('2018-04-29 02:13:25'), Timestamp('2018-04-29 02:36:10')], [12, Timestamp('2018-04-29 02:42:13'), Timestamp('2018-04-29 02:47:10')], [12, Timestamp('2018-04-29 02:53:20'), Timestamp('2018-04-29 02:57:35')], [12, Timestamp('2018-04-29 03:01:11'), Timestamp('2018-04-29 03:03:00')], [12, Timestamp('2018-04-29 03:10:08'), Timestamp('2018-04-29 03:20:55')], [12, Timestamp('2018-04-29 03:24:05'), Timestamp('2018-04-29 03:39:54')], [12, Timestamp('2018-04-29 03:46:03'), Timestamp('2018-04-29 04:08:15')], [12, Timestamp('2018-04-29 04:11:55'), Timestamp('2018-04-29 04:31:04')], [12, Timestamp('2018-04-29 04:34:07'), Timestamp('2018-04-29 04:36:47')], [12, Timestamp('2018-04-29 04:41:07'), Timestamp('2018-04-29 04:57:55')], [12, Timestamp('2018-04-29 05:05:17'), Timestamp('2018-04-29 05:09:09')], [12, Timestamp('2018-04-29 05:15:30'), Timestamp('2018-04-29 05:17:31')], [12, Timestamp('2018-04-29 05:23:10'), Timestamp('2018-04-29 05:56:32')], [22, Timestamp('2018-04-29 06:24:38'), Timestamp('2018-04-29 06:30:31')], [22, Timestamp('2018-04-29 06:34:40'), Timestamp('2018-04-29 06:38:06')], [22, Timestamp('2018-04-29 06:42:55'), Timestamp('2018-04-29 06:46:53')], [22, Timestamp('2018-04-29 06:56:24'), Timestamp('2018-04-29 07:05:16')], [22, Timestamp('2018-04-29 07:09:32'), Timestamp('2018-04-29 07:11:46')], [22, Timestamp('2018-04-29 07:20:48'), Timestamp('2018-04-29 07:34:15')], [22, Timestamp('2018-04-29 07:37:40'), Timestamp('2018-04-29 07:37:40')], [22, Timestamp('2018-04-29 07:40:45'), Timestamp('2018-04-29 07:41:30')], [22, Timestamp('2018-04-29 07:45:20'), Timestamp('2018-04-29 07:56:19')], [23, Timestamp('2018-04-29 08:06:40'), Timestamp('2018-04-29 08:06:40')], [23, Timestamp('2018-04-29 08:13:09'), Timestamp('2018-04-29 08:15:32')], [23, Timestamp('2018-04-29 08:25:41'), Timestamp('2018-04-29 08:32:05')], [23, Timestamp('2018-04-29 08:48:47'), Timestamp('2018-04-29 08:49:12')], [23, Timestamp('2018-04-29 08:53:30'), Timestamp('2018-04-29 09:07:38')], [23, Timestamp('2018-04-29 09:11:16'), Timestamp('2018-04-29 09:11:16')], [23, Timestamp('2018-04-29 09:19:49'), Timestamp('2018-04-29 09:20:36')], [23, Timestamp('2018-04-29 09:23:50'), Timestamp('2018-04-29 09:27:46')], [23, Timestamp('2018-04-29 09:32:45'), Timestamp('2018-04-29 09:43:41')], [23, Timestamp('2018-04-29 09:48:26'), Timestamp('2018-04-29 09:51:56')], [16, Timestamp('2018-04-29 09:56:49'), Timestamp('2018-04-29 10:11:44')], [16, Timestamp('2018-04-29 10:15:36'), Timestamp('2018-04-29 11:01:01')], [16, Timestamp('2018-04-29 11:05:08'), Timestamp('2018-04-29 11:08:03')], [16, Timestamp('2018-04-29 11:11:25'), Timestamp('2018-04-29 11:26:24')], [16, Timestamp('2018-04-29 11:30:04'), Timestamp('2018-04-29 11:36:08')], [16, Timestamp('2018-04-29 11:41:07'), Timestamp('2018-04-29 11:50:43')], [16, Timestamp('2018-04-29 11:55:41'), Timestamp('2018-04-29 11:57:25')], [18, Timestamp('2018-04-29 12:00:34'), Timestamp('2018-04-29 12:04:00')], [18, Timestamp('2018-04-29 12:11:36'), Timestamp('2018-04-29 12:13:51')], [18, Timestamp('2018-04-29 12:19:46'), Timestamp('2018-04-29 12:20:42')], [18, Timestamp('2018-04-29 12:24:37'), Timestamp('2018-04-29 12:36:22')], [18, Timestamp('2018-04-29 12:45:06'), Timestamp('2018-04-29 12:50:45')], [18, Timestamp('2018-04-29 12:55:22'), Timestamp('2018-04-29 13:09:31')], [18, Timestamp('2018-04-29 13:12:56'), Timestamp('2018-04-29 13:15:19')], [18, Timestamp('2018-04-29 13:18:57'), Timestamp('2018-04-29 13:31:14')], [18, Timestamp('2018-04-29 13:37:23'), Timestamp('2018-04-29 13:45:00')], [18, Timestamp('2018-04-29 13:49:37'), Timestamp('2018-04-29 13:56:52')], [4, Timestamp('2018-04-29 14:16:17'), Timestamp('2018-04-29 14:23:12')], [4, Timestamp('2018-04-29 14:26:13'), Timestamp('2018-04-29 15:28:49')], [4, Timestamp('2018-04-29 15:32:44'), Timestamp('2018-04-29 16:07:25')], [4, Timestamp('2018-04-29 16:12:50'), Timestamp('2018-04-29 16:39:19')], [5, Timestamp('2018-04-29 17:07:10'), Timestamp('2018-04-29 17:26:03')], [5, Timestamp('2018-04-29 17:30:08'), Timestamp('2018-04-29 18:45:52')], [5, Timestamp('2018-04-29 18:48:55'), Timestamp('2018-04-29 19:08:38')], [5, Timestamp('2018-04-29 19:12:58'), Timestamp('2018-04-29 19:36:52')], [10, Timestamp('2018-04-29 19:53:18'), Timestamp('2018-04-29 20:08:11')], [10, Timestamp('2018-04-29 20:13:45'), Timestamp('2018-04-29 21:29:27')], [12, Timestamp('2018-04-29 21:38:58'), Timestamp('2018-04-29 21:46:37')], [12, Timestamp('2018-04-29 21:50:51'), Timestamp('2018-04-29 21:52:56')], [12, Timestamp('2018-04-29 21:56:17'), Timestamp('2018-04-29 22:15:39')], [12, Timestamp('2018-04-29 22:18:57'), Timestamp('2018-04-29 23:46:55')], [12, Timestamp('2018-04-29 23:55:31'), Timestamp('2018-04-30 00:01:49')], [4, Timestamp('2018-04-30 00:10:17'), Timestamp('2018-04-30 00:40:32')], [4, Timestamp('2018-04-30 00:48:00'), Timestamp('2018-04-30 00:55:29')], [4, Timestamp('2018-04-30 01:00:13'), Timestamp('2018-04-30 01:09:45')], [4, Timestamp('2018-04-30 01:13:51'), Timestamp('2018-04-30 01:48:20')], [5, Timestamp('2018-04-30 01:51:48'), Timestamp('2018-04-30 02:56:33')], [5, Timestamp('2018-04-30 03:02:27'), Timestamp('2018-04-30 03:03:19')], [5, Timestamp('2018-04-30 03:08:11'), Timestamp('2018-04-30 03:12:47')], [5, Timestamp('2018-04-30 03:19:29'), Timestamp('2018-04-30 03:21:43')], [5, Timestamp('2018-04-30 03:25:15'), Timestamp('2018-04-30 03:31:57')], [5, Timestamp('2018-04-30 03:37:27'), Timestamp('2018-04-30 03:39:11')], [5, Timestamp('2018-04-30 03:44:20'), Timestamp('2018-04-30 03:44:40')], [20, Timestamp('2018-04-30 04:21:29'), Timestamp('2018-04-30 04:22:14')], [20, Timestamp('2018-04-30 04:25:39'), Timestamp('2018-04-30 05:52:48')], [20, Timestamp('2018-04-30 05:56:18'), Timestamp('2018-04-30 05:59:23')], [20, Timestamp('2018-04-30 06:03:32'), Timestamp('2018-04-30 06:07:41')], [20, Timestamp('2018-04-30 06:11:56'), Timestamp('2018-04-30 06:46:42')], [20, Timestamp('2018-04-30 06:49:58'), Timestamp('2018-04-30 07:24:53')], [20, Timestamp('2018-04-30 07:30:38'), Timestamp('2018-04-30 07:51:19')], [20, Timestamp('2018-04-30 07:54:37'), Timestamp('2018-04-30 07:56:34')], [20, Timestamp('2018-04-30 08:00:41'), Timestamp('2018-04-30 08:47:35')], [20, Timestamp('2018-04-30 08:51:41'), Timestamp('2018-04-30 08:54:45')], [20, Timestamp('2018-04-30 08:58:56'), Timestamp('2018-04-30 09:08:31')], [20, Timestamp('2018-04-30 09:12:17'), Timestamp('2018-04-30 10:13:54')], [20, Timestamp('2018-04-30 10:18:08'), Timestamp('2018-04-30 10:40:23')], [8, Timestamp('2018-04-30 10:53:54'), Timestamp('2018-04-30 12:01:15')], [8, Timestamp('2018-04-30 12:11:57'), Timestamp('2018-04-30 12:17:04')], [8, Timestamp('2018-04-30 12:20:18'), Timestamp('2018-04-30 12:32:32')], [8, Timestamp('2018-04-30 12:35:41'), Timestamp('2018-04-30 13:06:35')], [8, Timestamp('2018-04-30 13:10:02'), Timestamp('2018-04-30 13:18:34')], [8, Timestamp('2018-04-30 13:22:59'), Timestamp('2018-04-30 13:33:20')], [1, Timestamp('2018-04-30 13:46:49'), Timestamp('2018-04-30 13:50:56')], [1, Timestamp('2018-04-30 13:54:58'), Timestamp('2018-04-30 15:37:23')], [30, Timestamp('2018-04-30 16:20:42'), Timestamp('2018-04-30 16:45:23')], [30, Timestamp('2018-04-30 16:49:24'), Timestamp('2018-04-30 17:54:21')], [30, Timestamp('2018-04-30 17:58:32'), Timestamp('2018-04-30 18:13:15')], [30, Timestamp('2018-04-30 18:18:40'), Timestamp('2018-04-30 18:53:57')], [31, Timestamp('2018-04-30 19:06:42'), Timestamp('2018-04-30 19:56:50')], [31, Timestamp('2018-04-30 20:07:35'), Timestamp('2018-04-30 20:28:36')], [31, Timestamp('2018-04-30 20:32:08'), Timestamp('2018-04-30 21:22:59')], [31, Timestamp('2018-04-30 21:27:38'), Timestamp('2018-04-30 21:48:26')], [10, Timestamp('2018-04-30 21:58:37'), Timestamp('2018-04-30 22:45:05')], [10, Timestamp('2018-04-30 22:51:19'), Timestamp('2018-04-30 23:59:04')], [12, Timestamp('2018-05-01 00:26:26'), Timestamp('2018-05-01 00:26:26')], [12, Timestamp('2018-05-01 00:31:35'), Timestamp('2018-05-01 00:40:01')], [12, Timestamp('2018-05-01 00:50:06'), Timestamp('2018-05-01 00:53:24')], [12, Timestamp('2018-05-01 00:59:16'), Timestamp('2018-05-01 01:44:49')], [12, Timestamp('2018-05-01 01:48:12'), Timestamp('2018-05-01 02:04:34')], [12, Timestamp('2018-05-01 02:07:52'), Timestamp('2018-05-01 02:12:07')], [12, Timestamp('2018-05-01 02:23:44'), Timestamp('2018-05-01 02:23:44')], [12, Timestamp('2018-05-01 02:26:56'), Timestamp('2018-05-01 02:28:17')], [12, Timestamp('2018-05-01 02:32:52'), Timestamp('2018-05-01 02:42:04')], [12, Timestamp('2018-05-01 02:45:30'), Timestamp('2018-05-01 02:53:58')], [12, Timestamp('2018-05-01 02:58:11'), Timestamp('2018-05-01 03:05:30')], [12, Timestamp('2018-05-01 03:09:35'), Timestamp('2018-05-01 03:11:09')], [12, Timestamp('2018-05-01 03:24:23'), Timestamp('2018-05-01 03:24:23')], [12, Timestamp('2018-05-01 03:30:13'), Timestamp('2018-05-01 03:34:28')], [12, Timestamp('2018-05-01 03:39:34'), Timestamp('2018-05-01 03:39:34')], [12, Timestamp('2018-05-01 03:47:08'), Timestamp('2018-05-01 03:47:08')], [12, Timestamp('2018-05-01 03:51:31'), Timestamp('2018-05-01 03:59:26')], [12, Timestamp('2018-05-01 04:02:34'), Timestamp('2018-05-01 04:04:18')], [12, Timestamp('2018-05-01 04:08:49'), Timestamp('2018-05-01 04:17:51')], [12, Timestamp('2018-05-01 04:21:55'), Timestamp('2018-05-01 04:30:12')], [20, Timestamp('2018-05-01 05:11:01'), Timestamp('2018-05-01 05:26:25')], [20, Timestamp('2018-05-01 05:31:42'), Timestamp('2018-05-01 05:37:51')], [20, Timestamp('2018-05-01 05:44:15'), Timestamp('2018-05-01 05:59:19')]]
In [8]:
length_list = len(final_array)
print (length_list)

buckets = [0] * (unique_sets+1)
for i in range(length_list):
    a = final_array[i][0]
    buckets[a] +=  1

print (buckets)
1664
[0, 147, 76, 65, 223, 209, 87, 57, 123, 45, 57, 33, 178, 22, 23, 9, 34, 13, 45, 15, 54, 29, 19, 20, 16, 14, 2, 2, 10, 6, 9, 12, 5, 5]
In [ ]:
###Code for generating file, alerady generated so using the generated one
filename2 = 'analyses_data.xlsx'
pro_data = pd.read_excel(filename2, sheetname='RealtimeData')
pro_data['TIME'] = pd.to_datetime(pro_data['TIME'])

pro_data = pro_data.values
a,b = pro_data.shape
z = np.zeros((a,2))
pro_data = np.hstack((pro_data,z))
a,b = pro_data.shape

i = 0
print ("start")
while (i < a):
    t3 = pro_data[i][0]
    flag = 0
    j = 0
    while (j < length_list):
        t1 = pd.to_datetime(final_array[j][1])
        t2 = pd.to_datetime(final_array[j][2])
        time1 = pd.Timedelta(t2 - t3).seconds + pd.Timedelta(t2 - t3).days*24*60*60
        time2 = pd.Timedelta(t3 - t1).seconds + pd.Timedelta(t3 - t1).days*24*60*60
        time3 = pd.Timedelta(t2 - t1).seconds + pd.Timedelta(t2 - t1).days*24*60*60
        if (time1 >= 0 and time2 >= 0 and time3 >= 0 and (time1+time2 == time3)):
            pro_data[i][b-2] = final_array[j][0]
            pro_data[i][b-1] = j
            flag = 1
            break
        j += 1
    if (flag == 0):
        pro_data = np.delete(pro_data, i, 0)
        i = i - 1
        a,b = pro_data.shape
    i += 1
    
df = pd.DataFrame(pro_data)
filepath = 'my_excel_file.xlsx'
df.to_excel(filepath, index=False)
In [9]:
#filename3 = 'POWER_TTNR.xlsx'
filename3 = 'my_excel_file1.xlsx'

i = 1

############code addded on 22/6/2018#######
print (list1)
mean_standard = []
quantities_n = []
#########end############

#fig, axs = plt.subplots(unique_sets,1,figsize=(100,300))
#plot_count = 0
while (i <= unique_sets):
    df1 = pd.read_excel(filename3, sheetname='Sheet1')
    df1 = df1[df1.PRODUCT_TYPE == i]
    df1 = df1[["TIME","ACTIVEPOWER","PRODUCT_TYPE", "BATCH_TYPE"]]
    x = df1.BATCH_TYPE.unique()
    
    ################Code started for plotting graph ###################
    '''
    y_label = "Real Time Power of Product " + str(i)
    plt.subplot(221)
    plt.plot(df1['TIME'], df1['ACTIVEPOWER'])
    plt.title(str(i))
    plt.xlabel('time-stamp')
    plt.ylabel(y_label)
    plt.show()
    '''
    ####################Code ended for plotting graph###########
    
    #df1 = df1.values
    #a,b = df1.shape
    
    jj = []
    for kk in range(len(x)):
        jj.append([])
        df2 = df1[df1.BATCH_TYPE == x[kk]]
        df2 = df2.values
        aa, bb = df2.shape
        ref_time = 0
        for ll in range(aa):
            jj[kk].append(df2[ll][1])
    
    jj = pd.DataFrame(jj)
    median_var = jj.median()
    standard_deviation_from_mean_value = jj.std()
    max_value = jj.max()
    min_value = jj.min()
    mean_value = jj.mean()
    kkkkkkk = pd.Series.tolist(median_var)
    kkkkkkk1 = pd.Series.tolist(standard_deviation_from_mean_value)
    kkkkkkk1_numpy = np.asarray(kkkkkkk1)
    ppp = kkkkkkk1_numpy.size
    countttt_batch_size = 0
    for variables in range(ppp):
        if np.isnan(kkkkkkk1_numpy[variables]):
            countttt_batch_size += 1
    mean_std_dev = np.nanmean(kkkkkkk1_numpy)
    mean_standard.append(mean_std_dev)
    quantities_n.append(ppp - countttt_batch_size)
    print("standard deviation is " + str(mean_std_dev))
    kkkkkkk2 = pd.Series.tolist(max_value)
    kkkkkkk3 = pd.Series.tolist(min_value)
    kkkkkkk4 = pd.Series.tolist(mean_value)
    kkkkkkk5 = [b_i - a_i for a_i, b_i in zip(kkkkkkk1, kkkkkkk4)]
    kkkkkkk6 = [b_i + a_i for a_i, b_i in zip(kkkkkkk1, kkkkkkk4)]
    y_a = list(range(0, len(kkkkkkk)))
    y_label = "Real Time Power of Product " + str(i) + " kW"
    plt.figure(1, figsize=(20,10))
    plt.subplot(211)
    plt.plot(y_a, kkkkkkk, 'r', label='median/predicted')
    #plt.plot(y_a, kkkkkkk1, 'k', label='standard deviation from mean value')
    plt.plot(y_a, kkkkkkk5, 'brown', label='negative error')
    plt.plot(y_a, kkkkkkk6, 'coral', label='positive error')
    plt.title("product type" + str(i))
    plt.xlabel('time-stamp in minutes')
    plt.ylabel(y_label)
    plt.legend()
    plt.tight_layout()
    plt.subplot(212)
    plt.plot(y_a, kkkkkkk4, 'bx', label='mean power')
    plt.plot(y_a, kkkkkkk2, 'y', label='maximum power')
    plt.plot(y_a, kkkkkkk3, 'g', label='minimum power')
    plt.title("product type" + str(i))
    plt.xlabel('time-stamp in minutes')
    plt.ylabel(y_label)
    plt.legend()
    plt.tight_layout()
    plt.show()
    
    ##########second phase of code ending#########
    i += 1
    #plot_count += 1

#print (type(mean_standard))
print (mean_standard)
print (quantities_n)
##list1
###mean_standard
###quantities_n


print (mean_standard)
print (quantities_n)
print (list1)
list1_new = []
mean_standard_new = []
quantities_n_new = []
product_number = []
for i in range(len(mean_standard)):
    if str(mean_standard[i]) != 'nan':
        mean_standard_new.append(mean_standard[i])
        quantities_n_new.append(quantities_n[i])
        list1_new.append(list1[i])
        product_number.append(i)

mean_standard = mean_standard_new
quantities_n = quantities_n_new
list1 = list1_new
print (mean_standard)
print (quantities_n)
print (list1)
print (product_number)
width = 0.5
y_pos = np.arange(len(list1))
fig, ax = plt.subplots(figsize=(80, 40))
rects = ax.bar(y_pos, mean_standard, width ,color='r', align='edge' ,alpha=0.5)
ax.set_xticks(y_pos + width/2.)
ax.set_xticklabels(list1, fontsize=10)
ax.set_xlabel('TTNR')
ax.set_ylabel('standard deviation')
plt.legend()
def autolabel(rects,ii):
    for rect in rects:
        height = rect.get_height()
        values = quantities_n[ii]
        value1 = product_number[ii]
        value2 = mean_standard[ii]
        ii += 1
        ax.text(rect.get_x() + rect.get_width()/2., 1.08*height,
                '%s & prod. %d & std %f' %(str(values) , value1, value2),
                ha='center', va='bottom', fontsize=40)
autolabel(rects, 0)
plt.tight_layout()
plt.show()
['116_1038408484', '115_1038307052', '116_1038307052', '115_1038305585', '116_1038305585', '115_1038408318', '116_1038408318', '115_1038408484', '115_1038305594', '115_1038407804', '116_1038305594', '116_1038407804', '115_1038407806', '116_1038407806', '115_1038408272', '115_1038408104', '116_1038408272', '116_1038408104', '115_1038407334', '115_F005V16903', '116_1038407334', '115_1038408462', '116_1038408462', '115_1038407754', '116_1038407754', '115_1038305588', '116_1038305588', '115_1038407332', '116_1038407332', '115_1038408840', '116_1038408840', '115_1038305359', '116_1038305359']
standard deviation is 3.49936124956
standard deviation is 3.68703065716
standard deviation is 3.74880587682
standard deviation is 3.03753382962
standard deviation is 3.5994465014
standard deviation is 3.7842768957
standard deviation is 3.76760705638
standard deviation is 3.93105038429
standard deviation is 2.94690317458
standard deviation is 3.46660737528
standard deviation is 3.86932682109
standard deviation is 3.19571440861
standard deviation is 3.21471392671
standard deviation is 3.41499956132
standard deviation is 2.73417698283
standard deviation is 3.8423087534
standard deviation is 3.74496777538
standard deviation is 3.61773649728
standard deviation is 3.99828831384
standard deviation is 2.97462522947
standard deviation is 3.51180720468
standard deviation is 3.53286277084
standard deviation is 3.8769922273
standard deviation is 3.01843345583
standard deviation is 3.55200832146
C:\Program Files\Anaconda3\lib\site-packages\numpy\lib\nanfunctions.py:703: RuntimeWarning: Mean of empty slice
  warnings.warn("Mean of empty slice", RuntimeWarning)
standard deviation is nan
C:\Program Files\Anaconda3\lib\site-packages\numpy\lib\nanfunctions.py:703: RuntimeWarning: Mean of empty slice
  warnings.warn("Mean of empty slice", RuntimeWarning)
standard deviation is nan
standard deviation is 3.59222072684
standard deviation is 3.21508449045
standard deviation is 2.43887891229
standard deviation is 2.84117539626
standard deviation is 4.15791921042
standard deviation is 1.94461638021
[3.4993612495580368, 3.6870306571611344, 3.7488058768225527, 3.0375338296172174, 3.5994465013966233, 3.784276895700394, 3.7676070563774249, 3.9310503842926576, 2.9469031745838019, 3.4666073752802822, 3.8693268210946399, 3.1957144086139548, 3.2147139267096514, 3.4149995613224315, 2.7341769828343323, 3.8423087534031906, 3.744967775378214, 3.6177364972793216, 3.9982883138418761, 2.9746252294687774, 3.5118072046767335, 3.532862770841172, 3.8769922273043442, 3.0184334558342241, 3.5520083214647347, nan, nan, 3.5922207268351505, 3.2150844904493332, 2.438878912286393, 2.8411753962604567, 4.1579192104221345, 1.944616380212306]
[66, 54, 61, 92, 88, 75, 89, 103, 66, 75, 57, 46, 48, 53, 26, 64, 13, 52, 38, 81, 42, 37, 28, 47, 57, 0, 0, 15, 24, 49, 51, 20, 14]
[3.4993612495580368, 3.6870306571611344, 3.7488058768225527, 3.0375338296172174, 3.5994465013966233, 3.784276895700394, 3.7676070563774249, 3.9310503842926576, 2.9469031745838019, 3.4666073752802822, 3.8693268210946399, 3.1957144086139548, 3.2147139267096514, 3.4149995613224315, 2.7341769828343323, 3.8423087534031906, 3.744967775378214, 3.6177364972793216, 3.9982883138418761, 2.9746252294687774, 3.5118072046767335, 3.532862770841172, 3.8769922273043442, 3.0184334558342241, 3.5520083214647347, nan, nan, 3.5922207268351505, 3.2150844904493332, 2.438878912286393, 2.8411753962604567, 4.1579192104221345, 1.944616380212306]
[66, 54, 61, 92, 88, 75, 89, 103, 66, 75, 57, 46, 48, 53, 26, 64, 13, 52, 38, 81, 42, 37, 28, 47, 57, 0, 0, 15, 24, 49, 51, 20, 14]
['116_1038408484', '115_1038307052', '116_1038307052', '115_1038305585', '116_1038305585', '115_1038408318', '116_1038408318', '115_1038408484', '115_1038305594', '115_1038407804', '116_1038305594', '116_1038407804', '115_1038407806', '116_1038407806', '115_1038408272', '115_1038408104', '116_1038408272', '116_1038408104', '115_1038407334', '115_F005V16903', '116_1038407334', '115_1038408462', '116_1038408462', '115_1038407754', '116_1038407754', '115_1038305588', '116_1038305588', '115_1038407332', '116_1038407332', '115_1038408840', '116_1038408840', '115_1038305359', '116_1038305359']
[3.4993612495580368, 3.6870306571611344, 3.7488058768225527, 3.0375338296172174, 3.5994465013966233, 3.784276895700394, 3.7676070563774249, 3.9310503842926576, 2.9469031745838019, 3.4666073752802822, 3.8693268210946399, 3.1957144086139548, 3.2147139267096514, 3.4149995613224315, 2.7341769828343323, 3.8423087534031906, 3.744967775378214, 3.6177364972793216, 3.9982883138418761, 2.9746252294687774, 3.5118072046767335, 3.532862770841172, 3.8769922273043442, 3.0184334558342241, 3.5520083214647347, 3.5922207268351505, 3.2150844904493332, 2.438878912286393, 2.8411753962604567, 4.1579192104221345, 1.944616380212306]
[66, 54, 61, 92, 88, 75, 89, 103, 66, 75, 57, 46, 48, 53, 26, 64, 13, 52, 38, 81, 42, 37, 28, 47, 57, 15, 24, 49, 51, 20, 14]
['116_1038408484', '115_1038307052', '116_1038307052', '115_1038305585', '116_1038305585', '115_1038408318', '116_1038408318', '115_1038408484', '115_1038305594', '115_1038407804', '116_1038305594', '116_1038407804', '115_1038407806', '116_1038407806', '115_1038408272', '115_1038408104', '116_1038408272', '116_1038408104', '115_1038407334', '115_F005V16903', '116_1038407334', '115_1038408462', '116_1038408462', '115_1038407754', '116_1038407754', '115_1038407332', '116_1038407332', '115_1038408840', '116_1038408840', '115_1038305359', '116_1038305359']
[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 27, 28, 29, 30, 31, 32]
C:\Program Files\Anaconda3\lib\site-packages\matplotlib\axes\_axes.py:545: UserWarning: No labelled objects found. Use label='...' kwarg on individual plots.
  warnings.warn("No labelled objects found. "
In [ ]: